Reply To: Rapport DB export

#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