All computers report showing duplication of certain computers'

Article:TECH154808  |  Created: 2011-03-04  |  Updated: 2011-03-04  |  Article URL http://www.symantec.com/docs/TECH154808
Article Type
Technical Solution


Issue



The 'All Computers' report is showing duplicates of computers. This does not seem to happen with all computers in the List view but few.


Environment



CMDB Solution 7.1

Asset Management Solution 7.1


Cause



In the database Culture table, there is two culture records with the same PrimaryLanguageID, SubLanguageID and LCID but different culture
name. That is Simplified Chinese. So for the current All Computers report, unfortunately if any computer is using Simplified Chinese as its Windows OS’s
primary language, then the report will display a duplicate.


Solution



Follow the steps listed below:

1. Go to Reports > All Reports > Service and Asset Management > Picker Reports

2. Right click on the 'All computers' Report and Clone it.

3. Download the Attachment to this KB

4. Select the Cloned "All Computers' report and click on the edit button.

5. Under the Parameterize Query copy the sql from the AllComputersReportFix.sql and past it in this field.

6. Save Changes

Now we need to select the report to be used with Computer Resource

1. Go to Settings > All Settings > Notification Server > Resource and Data Class Settings > Resource Type > Asset Types > IT > Computers

2. Click on the link next to Associated reports

3. In the picker, browse down to the newly created report and select the new report.

4. Click OK

Now if you go to the computer resource it will be able to use the new report.

 


Attachments

AllComputersReportFix.sql (3 kBytes)

Supplemental Materials

SourceETrack
Value2280240
Description

All computers report showing duplication of certain computers’

https://engtools.engba.symantec.com/Etrack/readonly_inc.php?sid=etrack&incident=2280240



Article URL http://www.symantec.com/docs/TECH154808


Terms of use for this information are found in Legal Notices