Report Based on patches deployed on a particular date

Reporting
1

(imported topic written by rameshku)

Hi,

Is it possible for me to generate a report on the paches installed on a particular date. Option to choose a date and when a report is generated , should have the informations of the patches deployed on the partiocular date

Also Is it possible for me to choose a group of machines and genarate a report on the vulnerability details of the group.

Request your help me in acheiving this as this is one of my customer’s requirement.

2

(imported comment written by BenKus)

Hi rameshku,

Here is a custom report that will show you Fixlets that transitioned to “Not relevant” on a specific date (note that this will report on Fixlets that change to Not relevant even if something else patched/fixed it):

<?relevance (trs of ( td of name of computer of it & td of (name of fixlet of it) & td of (if (exists category of fixlet of it) then category of it else "n/a" ) & td of (id of fixlet of it as string) & td of (last became nonrelevant of it as string) ) ) of results whose (exists last became nonrelevant of it AND last became nonrelevant of it > ("19 Feb 2007 00:48:11 -0800" as time - 1*day) AND last became nonrelevant of it < ("19 Feb 2007 00:48:11 -0800" as time)) of bes fixlets ?>

You will need to change the two dates manually.

You can use the web reports filter dialog to filter to groups of computers/Fixlets. Note that this report can get very large and may be slow.

You can take this report to the next level and add a javascript box that lets you type in the times, but it is more work.

Ben

Computer Name Fixlet Name Category Fixlet ID Fixed Time
3

(imported comment written by rameshku)

Hi,

Thanks Ben…Will try this and update you.

Can you pls answer my second question also?.

4

(imported comment written by BenKus)

Hi rameshku,

Is it possible for me to choose a group of machines and genarate a report on the vulnerability details of the group.

The way you would do this is to create the report you want using web reports and filter the report to the group fo computers that you were interested in looking at.

Ben

5

(imported comment written by rameshku)

Hi Ben,

Thanks for your replies.

We had tried the first one of pulling out patch deployed details date wise.Below is the script we tried.

<?relevance (trs of ( td of name of computer of it & td of (name of fixlet of it) & td of (if (exists category of fixlet of it) then category of it else "n/a" ) & td of (id of fixlet of it as string) & td of (last became nonrelevant of it as string) ) ) of results whose (exists last became nonrelevant of it AND last became nonrelevant of it > ("26 Feb 2007 00:48:11 -0800" as time - 1*day) AND last became nonrelevant of it < ("26 Feb 2007 00:48:11 -0800" as time)) of bes fixlets ?>

In the output , we get one line like this.

cant generate report due to unknown reasons

Computer Name Fixlet Name Category Fixlet ID Fixed Time

Require your help in solving this.

Computer Name Fixlet Name Category Fixlet ID Fixed Time
6

(imported comment written by BenKus)

Hey rameshku,

Oops… Slight syntax mistake… forgot the “of fixlet” (see italics)…

<?relevance (trs of ( td of name of computer of it & td of (name of fixlet of it) & td of (if (exists category of fixlet of it) then category +of fixlet +of it else "n/a" ) & td of (id of fixlet of it as string) & td of (last became nonrelevant of it as string) ) ) of results whose (exists last became nonrelevant of it AND last became nonrelevant of it > ("26 Feb 2007 00:48:11 -0800" as time - 1*day) AND last became nonrelevant of it < ("26 Feb 2007 00:48:11 -0800" as time)) of bes fixlets ?>

Ben

Computer Name Fixlet Name Category Fixlet ID Fixed Time