Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

BSR-List Detection Rules and Associations

Created: 19 Oct 2012 • Updated: 24 Oct 2012 | 4 comments
Pascal KOTTE's picture
+2 2 Votes
Login to vote

Hi, did you ever try to delete a detection rule ? I share this item I built long time ago, and need today :)

Just import the XML below in a report area your console.

This query can be useful for detection rules but also other kind of items, just replace the '3CC607F3-C0E4-445B-A7B6-0D1FA4CA1EAA' with the Class Guid the Item type you want: more 1600 class I think :)

Here the simple SQL, but all the same short, such SQL can be hard to build, when don't know ;-)

/*pascal KOTTE 2010-06-01*/
SELECT     vItem.Name, vItem.Description, vItem_2.Name AS 'Child name', vItem.Guid as '_ItemGuid'
FROM         vItem FULL OUTER JOIN
                      vItem AS vItem_2 INNER JOIN
                      ResourceAssociation AS child ON vItem_2.Guid = child.ChildResourceGuid ON vItem.Guid = child.ChildResourceGuid
WHERE     (vItem.ClassGuid = '3CC607F3-C0E4-445B-A7B6-0D1FA4CA1EAA')
ORDER BY 'Child name'

Comments 4 CommentsJump to latest comment

Mistral's picture

This should be accessible in the console already.

  • Go to Manage -> All Resources
  • Select "Default"
  • To the right, click "Filter ..."
  • Check "HashedResource"

Now the inventory rules are displayed and you have your right click menu.

+3
Login to vote
Pascal KOTTE's picture

Great, I never see it was hidden below those 'HashedResource', thanks !

but my report also display "description" (ok useless, as copy paste the name...) and the associated child item (ok... most time same name also, but not allways :)
 
 

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

0
Login to vote
Mistral's picture

Didn't want to say your report isn't better than this. Just thought many people might not know :)

0
Login to vote
Pascal KOTTE's picture

And you are right, I was also forgot this option, I see once. Not often used, but important when extending item type usage n the CMDB.

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

0
Login to vote