Asset Management Suite

 View Only

Data Remediation Part VII: Cleaning Up Forwarding 

Nov 19, 2007 11:13 AM

This in essence creates a duplicate of the same resource across multiple NSs. Not very good if you are forwarding data at all. The examples of what can occur can be seen in each of the previous examples. One way to avoid this particular issue is to exclude resources which have been forwarded by another NS. This collection contains SQL code which will perform a lookup of resources located on the NS with those at the top level NS. If it finds a resource where the OwnerGUID is different with a more recent date then that correlates to another NS forwarding up a more recent copy of this same resource. You will need to edit the SQL to name your reporting/top level server. You can then use this collection within a filter to exclude these resources from being forwarded.

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 VI: Serial Number Comparisons


Data Remediation Part VIII: Additional Items

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
zip file
Computers Forwarded By Another NS.zip   2 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Nov 27, 2007 12:20 PM

Once you import the XML file, edit the item using the little pencil button and locate the section of code in the query area that reads this...
OPENQUERY('reportingserver','SELECT i.Guid, i.Name, i.OwnerNSGuid, a.[Client Date]
You want to the change the 'reportingserver' item to the name of your reporting server. Keep the single quotes around it.
Benjamin Z. Palmer
Architect | Workspace Design | The Hartford | Simsbury, CT 06082

Nov 26, 2007 04:51 AM

I am sorry that I am not a SQL guy, can you let me know where or which part need to change of the reporting/top level server?
Thanks

Related Entries and Links

No Related Resource entered.