Client Management Suite

Ok I have been searching tables and the forums... i do have some sql code for the resource page information...

but I cannot find for the life of me where to get the two im looking for. Anyone have any idea?

I want to write a report that shows active computers with no last configuration request date and/or last event received date.

We got this nice report from support last month.

I notice the sql is returning "is not null" so you may play around with that.

I will attach the report after I remove proprietary info.

Shows every computer known to the SMP. Items with blanks or 1900 dates are no data. Empty Agent Versions are not yet inventoried or not installed.</description>
      <name>Copy of All Computers - IsManaged, Last Inventory Update, IP Address

Here is the modified report - I replaced our server with "Server FQDN" - do a replace and you should get 4 instances.

Attachment(s)

Copy of All Computers - IsManaged, Last Inventory Update,...xml   13 KB 1 version

Thanks! report is pretty cool. I will definitely check it out...

but with that... I just threw the sql code from the xml into sql studio manager... and added a where vc.name = 'name of machine'

now for any machine with information im looking for it returns a value... however... for any computer that has blank information (which is what im trying to find) it does not show the machines in the report. I went and tested that against 8 of them. none show up but 5 that are in the report have last config request and last event received...

I would cheat and use excel. 

Copy all computer names to 1 column and then the computer name only results from this query to another - then remove duplicates.

Of course doing this weekly can be annoying, but if you do it quarterly - it will be OK.

And keep experimenting with the SQL in the meantime.