Client Management Suite

 View Only
  • 1.  Not able to export Installed Software report in Altiris.

    Posted Jun 10, 2013 10:10 AM

    Dear All,

    I need to export Installed software by computers, its shows 2000000 rows in report page but while its exported in spreadsheet(.csv format), i am not getting fully report. i think root cause is because of excel number of limited lines, but is there any way to export all the raws so that i can have full report of Installed Software by computers.



  • 2.  RE: Not able to export Installed Software report in Altiris.
    Best Answer



  • 3.  RE: Not able to export Installed Software report in Altiris.

    Posted Jun 10, 2013 10:22 AM

    This is because excel has space limit (65536/1,048,576). I have raised the idea against this issue. Kindly voteup so it will implement earlier

    https://www-secure.symantec.com/connect/ideas/file-splitting-if-overlimit



  • 4.  RE: Not able to export Installed Software report in Altiris.

    Posted Jun 10, 2013 10:25 AM

    On the time being you can use snapshot feature

    https://www-secure.symantec.com/connect/forums/snapshot-feature



  • 5.  RE: Not able to export Installed Software report in Altiris.

    Posted Jun 10, 2013 10:56 AM

    Hi,

    I got alternate solution like export needed report in Notepad and divide into two or multiple part of exported report(Notepad) in symantec forum, so how can i export report in notepad?

    please suggest.so that i can have temporary Solution..



  • 6.  RE: Not able to export Installed Software report in Altiris.
    Best Answer

    Posted Jun 10, 2013 11:02 AM

    You can open the csv file in notepad.

    Choose the multiple column and cut or paste in other notepad file and save in csv format.

    These way you can create multiple file

    Check

    https://www-secure.symantec.com/connect/forums/report-not-loaded-properly#comment-8737751



  • 7.  RE: Not able to export Installed Software report in Altiris.

    Posted Jun 13, 2013 04:53 AM

    Hi KNP,

    try this link its help full.

     
     
    http://www.symantec.com/connect/forums/how-show-report-result-more-50k-row-cms-71
     
    To change it system-wide, go to your coresettings.config file and change this line:
    <customSetting key="ReportMaxRowCount" type="local" value="50000" />
    It can be found in C:\ProgramData\Symantec\SMP\Settings.
    If you want to change that limitation for a single report, you will have to right click and choose Export. Then, find the embedded SQL and add this line at the very top:
    SET ROWCOUNT 0 --Unlimited
    If the report is simply running a stored procedure, then you will have to go into Management Studio and modify the stored proc directly and add that same line above.