Report on Resolved Incidents

acachero's picture
acachero
September 3rd, 2008

Currently we are using HD_Current View to report on incidents which status is 'Resolved'.
How else are other users recording their resolved incidents in Altiris?
What is the best way to do it?
If possible, can you please provide us with a sample SQL so that we can import it onto Altiris and see if it's right for us.
Thanks

Filed under: ,
0 votes
mboggs's picture
mboggs
1 year 27 weeks ago

Closed action

I use the status="Closed" and action="Closed" to capture those. 

workitem_status_lookup_value='Closed' and workitem_action='Closed' ORDER BY workitem_number ASC
0 votes
acachero's picture
acachero
1 year 27 weeks ago

Hi Mboggs, I used the

Hi Mboggs,
I used the Wizard and the query is stated below:

SELECT
T0.[workitem_number] AS 'Incident Number',
T0.[workitem_status_lookup_value] AS 'Status'
FROM [HD_workitem_current_view] T0
WHERE (T0.[workitem_action] = 'Closed'
AND T0.[workitem_status_lookup_value] = 'Closed') AND DATEDIFF(DAY, T0.[workitem_created_on], GETDATE()) <= %N Days%
ORDER BY T0.[workitem_number] ASC

However the results are coming up with incidents which have the created date of way past the 7 days that I declared in the paramaters.

I hope you're able to assist.

Thanks

0 votes
mboggs's picture
mboggs
1 year 27 weeks ago

variable

make sure your variable of N days is set to 7 in your report parameters and that the checkbox for Replace with SQL parameter is checked and the Prompt for value is NOT checked.

I used this SQL and hard coded 7 days and only get 7 days worth of results, so it must be your parameter.

0 votes