Client Management Suite

 View Only
Back to discussions
Expand all | Collapse all

I am looking for a bit of a walkthrough for creating or editing reports in CMS 7.1

  • 1.  I am looking for a bit of a walkthrough for creating or editing reports in CMS 7.1

    Posted Oct 30, 2012 01:04 PM

    I am looking for some detailed information on how to crate reporting for our location for specific needs, namely a full export of the database to a .mdb file that can be opened via access or some sort of csv file that is accessable from excel.  We want Altiris to replace the old and out of date database we have in access at present for inventory.

     

    Thank you.



  • 2.  RE: I am looking for a bit of a walkthrough for creating or editing reports in CMS 7.1

    Posted Oct 30, 2012 01:45 PM

    Why not just run reports on the database, rather than trying to make a copy of a complex database. Even if you could copy the whole database you instantly end up with yet another out of date database for inventory.

    As well as the Management Console, you can use IT Analytics to easily create your own reports, SQL Report Builder or the View Generator in SQL Server Management Studio.

    You'll find full instructions on writing Altiris reports in the Symantec Management Platform User Guide.

    A crash course on writing reports in SQL is here:

    https://www-secure.symantec.com/connect/articles/report-writing-endpoint-management-part-1

    Articles on using IT Analytics:

    https://www-secure.symantec.com/connect/articles/outstanding-articles-epm-reporting

    Note If you want to use the Advanced Report Builder in the 7.1 SP2 console you need MP1 installed.