Report Information: Removing Duplicate Netbios Names/computers in a ConfigMgr Report.
Running the following report category/Name "Software - Companies and Products; Computers w/specific software registered in Add Remove Programs" entered the proper parameters (values). The report displays duplicate machines, how do I remove the duplicate machines from this report? I have both Delete Inactive Client & Delete Obsolete Client configured in Site Maintenance if that matters? How do I remove the duplicate machines from this report? Thank you for your assistance...
April 9th, 2010 5:50pm

Start by cloning the report (right-click clone) and give it a different name so in case you mess up you didn't mess up the original. Then two possible changes... Change Select sys.netbios_name0 to have distinct, to get rid of duplicate identical rows, like Select Distinct sys.netbios_name0 the other change would be to change from v_r_system sys to instead use from v_r_system_valid sys Those are relatively easy ways to reduce the # of duplicates, and also to reduce the # of obsolete computers show up in reports.Standardize. Simplify. Automate.
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2010 6:00pm

Thank you for your response... It worked perfect!!
April 9th, 2010 7:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics