The attached stored procedure resolves the issue. To implement, follow these steps:
- Open SQL Management Studio and connect to the Symantec_CMDB database.
- Open a New Query window.
- Paste the contents in or open the attached SQL script.
- Execute the query.