But just I have SCCM Servers..nothing else.. Can we have working WQL query for the same
On Thu, Nov 14, 2013 at 1:45 AM, Marcum, John <[email protected]> wrote: > It's so much cooler to do it this way ;-) > > > > > http://myitforum.com/myitforumwp/2013/01/07/tracking-automatic-software-removals/ > > > > > > > > > * ------------------------------ * > > *John Marcum* > *Sr. Desktop Architect* > > *Bradley Arant Boult Cummings LLP* > ------------------------------ > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Ranvir singh > *Sent:* Wednesday, November 13, 2013 1:58 PM > *To:* [email protected] > *Subject:* [mssms] Creating Uninstall Collections Using Software Metering > > > > http://www.myitforum.com/articles/8/view.asp?id=10909 > > > > Showing as a Typo error after replacing the Rule ID as well > > > > 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 > INNER JOIN SMS_MeteredProductRule > > ON SMS_MeteredProductRule.RuleID = > SMS_MeteredFiles.RuleID > > > > > > WHERE SMS_MeteredFiles.RuleID = 6 > AND DateDiff(day, > SMS_G_System_SoftwareFile.ModifiedDate, GetDate()) > 30 > AND DateDiff(day, SMS_MeteredProductRule.LastUpdateTime, > 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. > >
