Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Run a report against a daily task

Updated: 21 May 2010 | 5 comments
rsather's picture
+1 1 Vote
Login to vote

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!

Comments

Gary_L's picture
07
Apr
2009
0 Votes 0
Login to vote

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

TheSmiz's picture
09
Apr
2009
0 Votes 0
Login to vote

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

rsather's picture
13
Apr
2009
0 Votes 0
Login to vote

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?

Joseph Swenson's picture
12
Nov
2009
0 Votes 0
Login to vote

 Was there ever a solution to

 Was there ever a solution to this?
running CMS7

Andrew Bosch's picture
12
Nov
2009
0 Votes 0
Login to vote

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