IT Management Suite

Hello,

We have been assigned a task to write a script that will fetch user selected report data from Altiris Console and that will be exported to an Excel sheet. I have been doing some research however, not had much luck on this.

It would be great if someone could be able to help or guide on this.

Thanks
Snm1502

You say user selected report data.  When the user is viewing the report you can configure report parameters which they can choose.   From there they can select Save as Spreadsheet.   Can you explain why this doesn't meet the need?

If you are looking for an automated report, you can use an automation policy to run a report and automatically email it to them on a set schedule.   I have several of these configured to email report data to various groups but I usually do it as HTML.  I think there is an option to attach it as a file but if there's not, I know you can do it directly from SQL reporting.

Thank you for the reply JoeVan. Yes, that allows us to save it as an excel. However, I guess my request wasn't clear... I meant this way,

User will execute (double click) a script (probably vbs), it would prompt the user with a drop down to select the desired report from the list of reports available in Altiris Console. Then user would click on a button something like Go... It would then fetch the data of the user selected report and paste or save it as an excel.

For a start, if drop down is not possible and report name would needed to be hard coded in script, would be ok. However, need something atleast at start with. All my researches are just failing. 

Hope I was able to explain it well this time.

Thanks
Snm1502