last date metering data collected for a client? (Full Version)

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager



Message

ssumgirl -> last date metering data collected for a client? (6/18/2008 12:23:22 PM)

Hey all - I have a handy sql query (sms report) i use to pull reports regarding the last time a client reported both hardware and software inventory, and I am wondering if anyone has a similar query that shows the last time metering data was collected from a client? I cant seem to find a table with an obvius name that might contain that data, so hoping someone mapped this turf before I do.

Thanks ahead of time.
-ssg



jnelson993 -> RE: last date metering data collected for a client? (6/18/2008 12:52:28 PM)

Isn't that the dbo.v_GS_SoftwareUsageData view?

SELECT
  MAX(StartTimeGMT) as LastStartTimeGMT
  ResourceID
FROM
  dbo.v_GS_SoftwareUsageData
GROUP BY
  ResourceID



dmandick -> RE: last date metering data collected for a client? (6/18/2008 1:05:28 PM)

I am feeling lazy - can you post the query you use to pull the last hardware and software inventory.  Thanks



skissinger -> RE: last date metering data collected for a client? (6/18/2008 1:39:01 PM)

I guess I'm lazier still; I use the built-in report "Inventory dates for a specific computer"



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.203125