Im working on SCCM 2007... So WQL Collection wont get it ?
On Tue, Sep 17, 2013 at 4:59 PM, Lindenfeld, Ivan <[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]] *On Behalf Of *Marcum, John > *Sent:* Tuesday, September 17, 2013 10:54 AM > *To:* '[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] <[email protected]>] *On > Behalf Of *Ranvir singh > *Sent:* Tuesday, September 17, 2013 9:33 AM > *To:* [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.**** > > ** ** > >
