Editing reports in notepad doesn't change scheduled job?

justinh

I have a custom report that I downloaded from the content exchange.  When I run the report inside NCM, it works fine, but when I run it as a job to email to me, I get the following:

"A column has been specified more than once in the order by list. Columns in the order by list must be unique."

followed by the SQL query which includes the following ORDER BY:

"ORDER BY SysName,NODES.SysName,ENTITY_PHYSICAL.Description"

So I edited the report in notepad, but nothing I did changed the error I receive via email.  I even removed the entire ORDER BY clause from the report.  When I run the report inside NCM, it does reflect the changes, but the same error keeps coming to me via email.

Any suggestions?

ElDeeBee

The following report fixed this issue.

This report is an unsupported version and will break if modified via the NCM report utility.

<Report Version="2.0" ReportType="Physical Entities" Schema="C:\Program Files (x86)\SolarWinds\Configuration Management\Schemas

\Node_Details.Schema" Category="User Defined" Title="Serial Number Report" SubTitle="" Description="" Footer=""
Grouping="SysName"
FieldList="ENTITY_PHYSICAL.Description,ENTITY_PHYSICAL.Serial"
DisplayStatus="FALSE"
IncludeConfigs="FALSE"
IncludeUnManaged="FALSE"
MergeLikeRows="FALSE"
Lines="Horizontal"
SQL="SELECT Nodes.*,[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Serial]
FROM Entity_Physical RIGHT JOIN Nodes ON Entity_Physical.NodeID = Nodes.NodeID
where [Entity_Physical].[Serial] is not null and [Entity_Physical].[Serial] != ''
ORDER BY [NODES].[SysName],[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Serial],Entity_Physical.Name"
SelectClause="SELECT Nodes.*,[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Serial]"
FromClause="FROM Entity_Physical RIGHT JOIN Nodes ON Entity_Physical.NodeID = Nodes.NodeID"
WhereClause="where [Entity_Physical].[Serial] is not null and [Entity_Physical].[Serial] != ''" OrderByClause="ORDER BY [NODES].

[SysName],[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Serial],Entity_Physical.Name"
TopX="All"
TopXCount="10"
TopXPercent="10" Orientation="Landscape">
<FieldSelection>
</FieldSelection>
<CriteriaSelection>
<QUERY>
<KIND>1</KIND>
<COMPLEX><TAG></TAG>
<CONNECTIVE>1</CONNECTIVE>
<CHECKED>1</CHECKED>
</COMPLEX></QUERY>
    </CriteriaSelection></Report>