Re: Web Reports, Shavlik, SUS feature pack

From: Garth (anonymous_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 19:39:24 -0400

The SQL query is a good starting point.

SELECT DISTINCT
app.Name0 AS 'WS Name',
installed.Expr1 AS 'Installed Updates',
app.Expr1 + installed.Expr1 AS 'Applicable Updates',
LEFT(ROUND((installed.Expr1 + 0.1) / (app.Expr1 + installed.Expr1 + 0.1) *
100, 2), 5) AS '% Compliant',
v_GS_WORKSTATION_STATUS.LastHWScan as 'Last Hardware Scan'
FROM
 (SELECT
 v_GS_COMPUTER_SYSTEM.Name0,
 COUNT(0) AS Expr1,
 v_GS_COMPUTER_SYSTEM.resourceid
 FROM
 v_GS_PATCHSTATE v_GS_PATCHSTATE,
 v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
 WHERE
 (v_GS_PATCHSTATE.Status0 = 'installed' AND
 v_GS_PATCHSTATE.resourceid = v_GS_COMPUTER_SYSTEM.resourceid)
 GROUP BY
 v_GS_COMPUTER_SYSTEM.Name0,v_GS_COMPUTER_SYSTEM.resourceid) installed
INNER JOIN
 (SELECT
 v_GS_COMPUTER_SYSTEM.Name0,
 COUNT(0) AS Expr1,
 v_GS_COMPUTER_SYSTEM.resourceid
 FROM
 v_GS_PATCHSTATE v_GS_PATCHSTATE,
 v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
 WHERE
 (v_GS_PATCHSTATE.Status0 = 'applicable'
 AND v_GS_PATCHSTATE.resourceid = v_GS_COMPUTER_SYSTEM.resourceid)
 GROUP BY
 v_GS_COMPUTER_SYSTEM.Name0,v_GS_COMPUTER_SYSTEM.resourceid) app
ON
 installed.Name0 = app.Name0,
v_GS_WORKSTATION_STATUS v_GS_WORKSTATION_STATUS
where
installed.resourceid = v_GS_WORKSTATION_STATUS.resourceid 

-- 
Garth Jones
www.MyITForum.com Columnist
http://www.myitforum.com/contrib/default.asp?cid=116
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:B486F055-F69C-4295-AF24-EA47379CEEE7@microsoft.com...
> I would like to know if anyone has a report that they use that contains
the
> following information when it comes to patch management:
> 1. Date of last scan
> 2. How many patches are installed
> 3. How many patches are missing( From this option maybe a drill down to
see
> the machine and all patches installed\not installed)
>
> Just pretty much looking for better web reports for the Patch Management
> portion of SMS 2003. Any help is greatly appreciated.
>
> Thanks
> Jason

Relevant Pages

  • Re: When is a Security patch not a patch?
    ... I'm the IT Security dude. ... security patches, real threats, etc.) and doing an impact analysis on them. ... there is no patch management procedure in place at all. ...
    (Security-Basics)
  • RE: Definitions
    ... Automated patch management is the ability to manage the deployment of ... patches through an automated tool. ... Since I am fairly new to some of the new definition in Security. ... Such requests, orders or instructions will ...
    (Security-Basics)
  • RE: Definitions
    ... patch management technology like HFNetCheckPro ... >patches through an automated tool. ... >interaction with one of our expert instructors. ... The security of electronic mail sent through the Internet ...
    (Security-Basics)
  • Re: PC-DOS 7 vs. PC-DOS 2000
    ... Didn't it also add the Euro currency sign?? ... Jason ... Is there any compelling reason to go out of my way ... > with several other links on the web to these patches. ...
    (comp.sys.ibm.ps2.hardware)
  • Re: Wizardry 8 and party-based RPGs
    ... Jason wrote: ... If you like those games then you would probably like Hired Guns. ... It's had a few patches now so most issues with the first release have been addressed. ...
    (comp.sys.ibm.pc.games.rpg)
Quantcast