Rapport DB export

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • October 2, 2006 at 7:43 pm #190
    Anonymous
    Inactive
    • Total Post: 161
    • Jacked into The Matrix
    • ★★★★★★

    We’re looking to write a connector that pulls data from the Rapport SQL DB. I’m not that familiar with Microsoft MSDE engine db’s. Can anyone shed some light on how to accompish this task?

    October 2, 2006 at 8:10 pm #8834
    karaziel
    Member
    • Total Post: 74
    • Back Stage Pass
    • ★★★★

    Its just a MS SQL database, so you’ll just need to identify what data you wish to retrieve and then use SQL queries.

    example:

    SELECT * FROM [RAPPORTDB].[DBO].[CLIENT]
    WHERE DATEDIFF(day, checkin, getdate()) >= 2

    This should return a list of all devices that are reported as actively checking into the Rapport server (based on your configured checkin intervals)

    Basically all the “Green” devices

    The connector details will vary on your programming language, but all center around using the SQL driver to locate and connect to the server then running a series of queries to poll data, either into a cached queue for manipulating on the fly or directly into another text file or DB.

    -k

    October 3, 2006 at 7:51 pm #8835
    karaziel
    Member
    • Total Post: 74
    • Back Stage Pass
    • ★★★★

    Here’s a query for the serial numbers of each device:

    use RapportDB
    select B.[ClientID], C.[Name], B.[Serial]
    from ClientHardware B, Client C
    where b.clientid = c.Clientid

    This will return the Name and Serial number of every device in the DB.

    -k

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.