Session Relevance Help

(imported topic written by SystemAdmin)

I’m trying to create a report that will be run with SOAP. I’m not really good with Session Relevance yet so if you all could help me that would be awesome! I need to create a report for patch fixlets that shows the following:

Name of Applicable Computer

ID of Fixlet

Name of Fixlet

Source of Fixlet

Source Severity of Fixlet

Category of Fixlet

Name of Site of Fixlet

Source ID of Fixlet (KB, etc.)

*Description of Fixlet

When Fixlet First Became Relevant

When Fixlet Last Became Non-Relevant

When Fixlet Last Became Relevant

*I cannot find session relevance for Description of Fixlet.

Here is what I have so far, but when I added the last three items I began getting error, “Singular expression refers to non-unique object”.

Please help.

(  item 0 of it as string  & 
"$x$" & item 1 of it as string  & 
"$x$" & item 2 of it as string  & 
"$x$" & item 3 of it as string  & 
"$x$" & item 4 of it as string  & 
"$x$" & item 5 of it as string  & 
"$x$" & item 6 of it as string  & 
"$x$" & item 7 of it as string  & 
"$x$" & (

if ((year of date (local time zone) of it) as integer = 1980) then (
"<none>") 

else ( (year of it as string & 
"/" & month of it as two digits & 
"/" & day_of_month of it as two digits) of date (local time zone) of it & 
" " & (two digit hour of it as string & 
":" & two digit minute of it as string) of time (local time zone) of it)) of (item 8 of it as time) & 
"$x$" & (

if ((year of date (local time zone) of it) as integer = 1980) then (
"<none>") 

else ( (year of it as string & 
"/" & month of it as two digits & 
"/" & day_of_month of it as two digits) of date (local time zone) of it & 
" " & (two digit hour of it as string & 
":" & two digit minute of it as string) of time (local time zone) of it)) of (item 9 of it as time) & 
"$x$" & (

if ((year of date (local time zone) of it) as integer = 1980) then (
"<none>") 

else ( (year of it as string & 
"/" & month of it as two digits & 
"/" & day_of_month of it as two digits) of date (local time zone) of it & 
" " & (two digit hour of it as string & 
":" & two digit minute of it as string) of time (local time zone) of it)) of (item 10 of it as time)) of ( (

if (exists Names of Applicable Computers of it) then (Names of Applicable Computers of it as string) 

else (
"<none>")), (

if (exists ID of it) then (ID of it as string) 

else (
"<none>")), (

if (exists Name of it) then (Name of it as string) 

else (
"<none>")), (

if (exists Source of it) then (Source of it as string) 

else (
"<none>")), (

if (exists Source Severity of it) then (Source Severity of it as string) 

else (
"<none>")), (

if (exists Category of it) then (Category of it as string) 

else (
"<none>")), (

if (exists Names of Sites of it) then (Names of Sites of it as string) 

else (
"<none>")), (

if (exists Source ID of it) then (Source ID of it as string) 

else (
"<none>")), (

if (exists First Became Relevant of results of it) then (First Became Relevant of results of it as string) 

else (
"Fri, 15 Feb 1980 00:00:00 -0000")), (

if (exists Last Became Nonrelevant of results of it) then (Last Became Nonrelevant of results of it as string) 

else (
"Fri, 15 Feb 1980 00:00:00 -0000")), (

if (exists Last Became Relevant of results of it) then (Last Became Relevant of results of it as string) 

else (
"Fri, 15 Feb 1980 00:00:00 -0000"))) of bes fixlets whose ( (name of site of it = 
"Patches for AIX" OR name of site of it = 
"Patches for RHEL 4" OR name of site of it = 
"Patches for RHEL 5" OR name of site of it = 
"Patches for RHEL 6" OR name of site of it = 
"Patches for RHEL5 Dependency Resolution" OR name of site of it = 
"Patches for Solaris" OR name of site of it = 
"Enterprise Security") AND ((Fixlet Flag of it = True) AND (Globally Visible Flag of it = True) AND (Applicable Computer Count of it > 0)))

(imported comment written by cstoneba)

here’s something similar that might helped that I created to show me computers that are pending restart:

(name of computer of it as string,

id of fixlet of it as string,

name of fixlet of it as string,

first became relevant of it as string,

last became relevant of it as string

)

of results from (bes fixlets whose (name of it = “Restart Needed - Triggered by a BES Action” and fixlet flag of it = true)) of applicable computers of bes fixlets whose (name of it as lowercase = “restart needed - triggered by a bes action”)

(imported comment written by SystemAdmin)

Thanks for the reply Chris. I’ve done what you’ve listed before for something similar, however I really need the other properties that I am trying to pull also. When I combine all these properties together that is when I get my problems.