Data Remediation Part VIII: Additional Items
cnpalmer75
November 28th, 2007
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
Further Comments...
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
When Running the above script
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
Would you like to reply?
Login or Register to post your comment.