none
WSUS WID Database Reports RRS feed

  • Întrebare

  • Hello Guys,

     WSUS Report is not good, I need to create patch compliance reports with query in WSUS with WID Database.

    Type of report i want:

    • Report for Computers Groups individually
    • Report computers with Pending Reboot
    • Report for computer with downloaded state
    • Report for computer with error installing and the reason

    This a example of Report that i found in google, maybe need some modification to obtain my request, any Database or WSUS expert that can help me.


    USE SUSDB
     
    SELECT
    LEFT(comp.Name,30) as 'Computer Name',
    count(COMP.Name) as 'Number of missing updates',
    COMP.IPAddress AS 'IP Address',
    COMP.LastSyncTime AS 'Last Sync Time',
    COMP.OSArchitecture AS 'OS Architecture',
     CASE
     CAST (COMP.OSMajorVersion AS varchar(50)) + CAST ('.' AS varchar(50))
     + CAST (COMP.OSMinorVersion AS varchar(50)) + CAST ('.' AS varchar(50))
     + CAST (COMP.OSBuildNumber AS varchar(50))

     

    miercuri, 11 decembrie 2019 03:03