If you know the GUID of the policy fragment, then you can go into mysql on the gateway and perform a query on the ssg database for that information.
-------
- Open up a text editor like Notepad and copy: SELECT name FROM policy WHERE xml LIKE '%stringValue="fragment-GUID-#"%';
- Open up the Policy Manager and right click on your Policy Fragment, and choose Policy Properties. Right click on Policy GUID area, and select Copy.
- Go back to Notepad and replace the fragment-GUID-# with the Policy GUID of your fragment you just copied, by pasting it.
- (This new SELECT statement will be passed in mysql)
- Login to your gateway either manually or via SSH. At root command line type: mysql -> use ssg; -> SELECT name FROM policy WHERE xml LIKE '%stringValue="fragment-GUID-#"%';
- (Remember to use your new SELECT statement with the Policy GUID replacing the fragment-GUID-#)
-------
Example SQL command:
-------
This will print the names of the services containing this policy fragment.
Hope this helps.