Client Management Suite

 View Only

  • 1.  Report showing all servers in patch compliance

    Posted Jun 13, 2012 04:42 AM

    Anyone got the sql statement for showing ALL servers and their patch compliance. I adjusted the Windows Compliance by computer and put %server% in the OS - it shows a lot of servers but not all for some reason.

    Joe.



  • 2.  RE: Report showing all servers in patch compliance
    Best Answer

    Posted Jun 13, 2012 05:05 PM

    If I understand you, then you have used '%server%' in your filter/ where clause for the OS name?

    Looking at our environment and the versions of Windows deployed, the only OS you would not see is Windows 2000 servers.



  • 3.  RE: Report showing all servers in patch compliance

    Posted Jun 14, 2012 04:04 AM

    Hi Ian, yep I did that - It eventually showed all the servers - just seemd to take upto a day for this to ahppen.

    Thanks

    Joe.