Action status of Not Reported

Content Authoring
1

I am trying to grab some results based on an action in custom report but not reported machines are not coming in, what I am missing in below code.

(name of computer of it, last report time of computer of it, status of it as string | “Not Reported”, state of action of it, (start date of action of it & (start time_of_day of action of it & local time zone)) | time issued of action of it, (end date of action of it & (end time_of_day of action of it & local time zone)) as string | “N\A”) of results of bes actions whose (name of it starts with “not_reported_test”)

2

I think the issue is that results of bes actions will not exists if the computer has not reported. You may need to use bes actions and then you could add something like if(exists results of it) then (status of results of it as string) else ("Not Reported")

Just as an example, (names of targeted computers of it, last report time of targeted computers of it, (if(exists results of it) then (status of results of it as string) else ("Not Reported")), state of it) of bes actions whose (name of it starts with "not_reported_test")

2 Likes
3

Not sure I have used above it should have showed it even if its not there.

tried yours but still no luck.

Have also tried to look using excel connector but that also not giving any results.

    (if (exists ID of Action of it) 
		then (concatenations "%0A" of (ID of Action of it as string)) 
		else ("<none>")), 
	(if (exists Name of Issuer of Action of it) 
		then (concatenations "%0A" of (Name of Issuer of Action of it as string)) 
		else ("<none>")), 
	(if (exists Name of Action of it) 
		then (concatenations "%0A" of (Name of Action of it as string)) 
		else ("<none>")), 
	(if (exists State of Action of it) 
		then (concatenations "%0A" of (State of Action of it as string)) 
		else ("<none>")), 
	(if (exists Time Issued of Action of it) 
		then (Time Issued of Action of it as string) 
		else ("Fri, 15 Feb 1980 00:00:00 -0000")), 
	(if (exists Name of Computer of it) 
		then (concatenations "%0A" of (Name of Computer of it as string)) 
		else ("<none>")), 
	(if (exists Last Report Time of Computer of it) 
		then (Last Report Time of Computer of it as string) 
		else ("Fri, 15 Feb 1980 00:00:00 -0000")), 
	(if (exists Status of it) 
		then (concatenations "%0A" of (Status of it as string)) 
		else ("<none>")), 
	(if (exists Detailed Status of it) 
		then (concatenations "%0A" of (Detailed Status of it as string)) 
		else ("<none>"))) 
of 
	results
		  whose (((ID of Action of it = 20582))) 
	of bes actions