Post reply

SCCM Reports

  • August 29, 2012 at 10:48 pm

    #266787

    Hi,

    I have tried and tried and I seem to be missing some thing and I think its understanding the structure of SCCM.

    I need to develop a report for Windows security update effectiveness

    Desktops % having all Windows security updates

    Average time to deploy updates: average time from when update was released to when it was deployed to collection Company – Workstations (PRODUCTION), in days rounded up to nearest day

    Average time for updates to be installed: complex formula, see below

    Servers % having all Windows security updates

    Average time for updates to be installed: complex formula, see below

    “Having all Windows security updates” is defined as: for all security updates, if the update was required for the target, the update has been installed. Exclude superseded and expired updates.

    For average time for updates to be installed, the method would be:

    Time to install an update = (date updated installed, or current date if update is not installed) - (later of: date update was released, or system install date)

    Result to report = average of all the Time to install for all updates on all systems being reported, in days, rounded up to nearest day

    This is to avoid systems that are recloned or deployed after the update was released causing the metrics to go crazy.

    Does this make any sense to any one as I am lost.

    Appreciate all and any help.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • August 30, 2012 at 2:04 am

    #1531749

    Maybe this will help http://www.microsoft.com/en-us/download/details.aspx?id=22052

  • August 30, 2012 at 6:13 pm

    #1532165

    Appreciate that. Thanks 🙂

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply