myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


last date metering data collected for a client?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> last date metering data collected for a client? Page: [1]
Login
Message << Older Topic   Newer Topic >>
last date metering data collected for a client? - 6/18/2008 12:23:22 PM   
ssumgirl

 

Posts: 178
Score: 0
Joined: 11/24/2004
Status: offline 		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
Post #: 1
RE: last date metering data collected for a client? - 6/18/2008 12:52:28 PM   
jnelson993


Posts: 731
Score: 91
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Isn't that the dbo.v_GS_SoftwareUsageData view?

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


_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to ssumgirl)
Post #: 2
RE: last date metering data collected for a client? - 6/18/2008 1:05:28 PM   
dmandick

 

Posts: 10
Score: 0
Joined: 7/14/2006
Status: offline 		I am feeling lazy - can you post the query you use to pull the last hardware and software inventory.  Thanks

(in reply to jnelson993)
Post #: 3
RE: last date metering data collected for a client? - 6/18/2008 1:39:01 PM   
skissinger


Posts: 1856
Score: 123
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		I guess I'm lazier still; I use the built-in report "Inventory dates for a specific computer"

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
Microsoft MVP - ConfigMgr

(in reply to dmandick)
Post #: 4
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> last date metering data collected for a client? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.219