SQL Reporting Question
04/15/2015 1513 views
I've gotten pretty familiar with reporting using existing data from within the K1000 but what if I wanted to query using an external source such as a user list csv?
Use case would be spitting out our current active users from LDAP into a CSV then feeding that into the reporting engine to spit out all the users it found that have devices and perhaps those who don't have a device. This would help tremendously in keeping track of currently deployed machines as our inventory and user database have grown so much and include retired machines or in-storage/waiting to be deployed machines.
Anyone have a way to accomplish this or will I have to manually update a large sql query every time?
Thanks for any help!