Asset Management Suite

 View Only
Back to Library

Data Remediation Part VIII: Additional Items 

Nov 28, 2007 12:29 PM

There is a section in the SQL that will allow you to control how many resources are merged at once (TOP 10). You can choose to change this to any number you'd like.

Also included is an output (PRINT) statement to see what resources were merged.

Finally, this script will only merge those resources where the duplicate count is 2 (COUNT = 2). Anything that has more than one duplicate you'll have to run that mind-numbing manual report.

License: AJSL
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
Support: User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.


Data Remediation Part VII: Cleaning Up Forwarding

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
​
Attachment(s)
zip file
Resource Merge Duplicate Serial Number + MAC.zip   1 KB   1 version
Uploaded - Feb 25, 2020
 
Download

Tags and Keywords

Comments

Migration User
Jan 13, 2009 06:05 AM

When Running the above script I receive the following message
Warning: Null value is eliminated by an aggregate or other SET operation.
Now merging 12DA611E-6FF4-41F6-A0DF-C8BF3219EBAD into 89C2814A-B772-4436-A0B2-A446AF759FEF
(0 row(s) affected)
Now merging CE4A5D64-5F24-463F-9B7D-CE7FB8AFFB4D into F1CFB665-5E85-4DCC-85AF-7AF8ECBA0BFF
(0 row(s) affected)
Now merging 6B7D478D-5380-4285-8DF1-DF0068BF2F6F into E0C9667B-DDA6-4B54-B871-494E9E563B01
(0 row(s) affected)
Now merging AD8371A3-53FE-4682-B298-E7C227EA213B into 5C7029A9-F3E9-4CC1-BB74-42189252DDEB
(0 row(s) affected)
Now merging F13A031F-A59A-4F9A-8280-F88F52EEE375 into 4CE6B4FE-9E28-4011-984F-0C8979007271
(0 row(s) affected)
Any Thoughts as to why

Migration User
Nov 28, 2007 02:50 PM

If you don't want to see the output of the script you can comment out the PRINT section in one of 2 ways.
Line by line you can using --
OR
By the entire section by using /* and */
Here are examples...
--comments one line
--at a time
/*comment multiple lines
of text between these characters*/
Benjamin Z. Palmer
Architect | Workspace Design | The Hartford | Simsbury, CT 06082

Related Entries and Links

No Related Resource entered.