It should. My point is if those tasks have not run that could be why the data is not populated in the database.
________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Ranvir singh Sent: Tuesday, September 17, 2013 11:04 AM To: [email protected] Subject: Re: [mssms] Software Metering Collection Im working on SCCM 2007... So WQL Collection wont get it ? On Tue, Sep 17, 2013 at 4:59 PM, Lindenfeld, Ivan <[email protected]<mailto:[email protected]>> wrote: Two related to Software Metering: Summarize Software Metering File Usage Data Summarize Software Metering Monthly Usage Data CM12 Ivan Lindenfeld Sr. Systems Engineer Enterprise Deployment / SCCM Fidelity National Financial Jacksonville, Florida From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Marcum, John Sent: Tuesday, September 17, 2013 10:54 AM To: '[email protected]<mailto:[email protected]>' Subject: RE: [mssms] Software Metering Collection I think there's a maintenance task that needs to run to summarize the data. ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Ranvir singh Sent: Tuesday, September 17, 2013 9:33 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Software Metering Collection I just need to create the collection for Last 30 day Adobe.exe application not used machine data.. I have already enabled the metering rule.. But im not getting any out put.. I can ble to see the data from the default report.. But when i create the collection using below query ,not populating any data.. Any Help ? http://www.myitforum.com/articles/1/view.asp?id=10909 To create a collection we need to base this on the SYS_R_System class. We also introduce a WHERE clause to limit by Operating System, to exclude servers: SELECT DISTINCT SMS_R_System.* FROM SMS_G_System_SoftwareFile INNER JOIN SMS_R_System ON SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID INNER JOIN SMS_MeteredFiles ON SMS_G_System_SoftwareFile.FileID = SMS_MeteredFiles.MeteredFileID WHERE SMS_MeteredFiles.RuleID = 6 AND DateDiff(day, SMS_G_System_SoftwareFile.ModifiedDate, GetDate()) > 30 AND SMS_R_System.OperatingSystemNameAndVersion LIKE '%Workstation%' AND SMS_G_System_SoftwareFile.ResourceID NOT IN ( SELECT DISTINCT SMS_MonthlyUsageSummary.ResourceID FROM SMS_MonthlyUsageSummary INNER JOIN SMS_MeteredFiles ON SMS_MonthlyUsageSummary.FileID = SMS_MeteredFile.MeteredFileID WHERE DateDiff(day, SMS_MonthlyUsageSummary.LastUsage, GetDate()) < 90 AND SMS_MeteredFiles.RuleID = 6 ) ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
