MoffattD Trusted Contributor.
Trusted Contributor.

Report Question

I was wondering if it was possible to create a report that shows computers in ZCC that have no inventory collected. The reason I ask is, when I run reports, they are often not accurate as we have some computers that the inventory has not been collected yet, or the Agent is not communicating with the server. If I could find out which computers are not being inventoried, I can pro actively fix the Agent and get a more accurate report.

Hope this makes sense.

Labels (1)
1 Reply
gturcsik Absent Member.
Absent Member.

Re: Report Question

Hi Darren,

We use this sql query to run on the DB and find the workstations what never collected the inventory:

select * from zDevice where ZUID not in (select ZenWorksAgentId from NC_Workstation)

If you have report server you can create a riport to find this machines and can schedule and send automatically on email.
You cannot use ZCC reports, because it use only the inventory tables.
