Search This Blog

Tuesday, January 25, 2011

Machines Which Has Last Software Scan ( WQL Query)

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_LastSoftwareScan on SMS_G_System_LastSoftwareScan.ResourceId = SMS_R_System.ResourceId where SMS_G_System_LastSoftwareScan.LastScanDate < DateAdd(dd,-30,GetDate())
Posted by at

6 comments:

  1. UnknownJune 11, 2018 at 2:22 AM

    This comment has been removed by the author.

    ReplyDelete
  2. UnknownJune 11, 2018 at 2:22 AM

    Great query - just used to find 50 x machines which the last SS was done 30 days ago.
    How do I find which machine have no software scan done at all?
    Thanks

    ReplyDelete
  3. brittanymlemaySeptember 14, 2019 at 2:09 AM

    Thank you very much for the sharing! COOL.. Open Source Crowdfunding Software

    ReplyDelete
  4. RobertMay 11, 2021 at 3:16 AM

    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. perfect for scheduling clients

    ReplyDelete
  5. Quinn PrazakJune 19, 2021 at 2:22 AM

    Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post.

    ReplyDelete
  6. Benjamin S. WilsonJuly 9, 2021 at 12:31 AM

    The information you have posted is very useful. The sites you have referred was good. Thanks for sharing... bookmetoday.com

    ReplyDelete

Subscribe to: Post Comments (Atom)