KB30904: How to Get a List of Security Filters that are Currently Linked to Users Using the MicroStrategy Intelligence Server SDK 10.x

Using the Strategy Intelligence Server SDK 10.x, it is possible to get a list of all security filters that are currently linked to a user object. This type of customization can be helpful when trying to determine which security filters are or are not being used by a particular project.
 
A Link object is used to create an association between two objects such as a user and a security filter, report and a schedule, etc.
 
The following code demonstrates how to use the IDSSLink and IDSSLinkItem objects to get this information:
 

Dim oLinkItems As IDSSLinkItems
Dim oLinkItem As IDSSLinkItem

Dim oSecLink As IDSSLink
Dim oUser As IDSSUser
Dim oFilter As IDSSMDSecurityFilter
Dim oProject As IDSSProject

Set oProject = ProjectSession.ObjectSource.Project
Set oSecLink = oProject.SystemLink(DssSystemLinkMDSecurity)

'set security link items
Set oLinkItems = oSecLink.NewLinkItems
oLinkItems.FindItems

MsgBox oLinkItems.Count

For Each oLinkItem In oLinkItems
	Set oFilter = oLinkItem.ItemByType(DssTypeMDSecurityFilter)        
	Debug.Print "Filter Name: " & oFilter.Info.Name        
Next

 
 
 
CUSTOMIZATION WARNING:
 
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.