Client Management Suite

My customer want to show customize report more than 50K row on CMS 7.1.

Please suggest me.

Best regards.

In Altiris 6 you could add SET ROWCOUNT 999999 This would increase the maximum rows returned. Worth a try. You must edit Sql directly.

Dear Kchroeder

thx for your reply but my customer use CMS 7.1 not 6, and result of SQL query show more than 50K row (i does not add "SET ROWCOUNT 999999" on SQL statement)

please suggest me.

Best regards.

Hallo Sukhum

This KB might be worth a shot ;) - allthough it seems as a setting you need to configure on everything which i would say is something you need to be carefull with doing. :)

http://www.symantec.com/business/support/index?page=content&id=HOWTO9887

Kind Regards
Morten Leth

Dear mortenleth

On CMS 7.1 i cannot find NSConfigurator.msi and i think KB is support NS 6.0 or 7.0 not support 7.1

Thx

Hallo Sukhum

This feature is something which isn't needed to install, it's built in.
You can find it under:

C:\Symantec\Altiris\Notification Server\Bin\Tools

given you have installed in under your C:\ drive with the default installation path.
I had problems opening it, but if you open a commandprompt with "run as administrator" it will run just fine.

Secondly i had problems finding that key, but you might have more luck than i have, i didn't look much into it.

Kind Regards
Morten Leth

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.

I've also noticed that the returned results in the Activity Center console will also limit itself to only 50K records. I have adjusted the returned results using the Enhanced Console Views settings to the 1st 1K records but the results will indicate 1000 records returned out of 50K. I know this to be untrue as we have close to 65K newly discovered software titles.

Dear Andrew Bosch 

thx for your reply.

for SET ROWCOUNT 0 --Unlimited : is not work

i think i will modify coresettings.config but i not sure effect on NS.

question

after i modify coresettings.config  next step i will do (example restart IIS or restart server)

Dear mortenleth

thx , i cannot find ReportMaxRowCount key after open NSConfigurator.msi :-

best regards.