(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)))