SQL Reporting Question
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!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 years ago
Are your LDAP users being imported into KACE? If they are then you can use the USERS table for your reporting.
