Run a report against a daily task
Updated: 21 May 2010 | 5 comments
I am fairly new to Altiris (again - used it years ago in a previous job) Currently I am running CMS 6.9 while we work on our Migration plan to 7.
I would like to create a report to show me the results of a Client Task that is running daily with the Resource name, Status, Completion Time, Return Code & Script Errors if possible that I'd setup to email several people on a daily basis who need to take action on the outcome, but not neccesarily be in the Altiris Console. I may be completely missing an easy way to do this, but can't find a similar report to clone and tweak.
Any help or suggestions would be appreciated!
discussion Filed Under:
Comments
There are some good reports
There are some good reports on altirigos.com for task results...
Click on Misc - Reports and Queries
http://www.altirigos.com/repository/categories.php
Click on Manage -- Reports,
Click on Manage -- Reports, right-click on "Reports" and select New -- Report.
Add a report name and description and select enter SQL sirectly and use something like:
SELECT it.Name AS TaskName,
vc.Name AS ComputerName,
vc.Guid AS ComputerGuid,
st.Status AS TaskStatus,
st.ExitCode AS TaskReturnCode,
st.AttemptTime AS TaskAttemptTime
FROM inv_synch_status st
INNER JOIN vcomputer vc on vc.guid = st._resourceguid
INNER JOIN item it on st.taskid = it.guid
Where st.SynchronizationId in (
SELECT Guid
FROM Item
WHERE Name = 'TaskNameHere')
Order by it.name
Put the name of your task in place of "taskNameHere" above. Click "test" to see if any results are returned. If you like what you see, click "Finish". You will be taken to the report page and you can now schedule this report to run and have it send and email when it does.
RS
No luck so far...
Gary - I found some nice reports, but non that would report against a task.
TheSmiz - I tried your suggestion several ways and could not get it to work, does it matter that my task name has spaces? I would think not since it's on quotes?
Was there ever a solution to
Was there ever a solution to this?
running CMS7
Task Server Status Reports
In 7.x go under Reports -> All Reports and then look for the Task Server -> Status folder - there are quite a few canned reports there.
------------------------------------
Principal SQA Engineer
Symantec
Would you like to reply?
Login or Register to post your comment.