Video Screencast Help

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