Rapport DB export

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #190
    AvatarAnonymous
    Member
    • Total Post: 162
    • 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?

    #8834
    Avatarkaraziel
    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

    #8835
    Avatarkaraziel
    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

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