Metadata Explorer – platformadmin.com

Sometimes you want to find all of the SAS metadata objects a user may be associated with. Where SAS applications have tagged a user as a ResponsibleParty, we can use the Metacoda Metadata Explorer with an advanced XMLSELECT style query to find them. Use the following query (including curly braces) in the Search field, replacing the Name value (demobob here) with the name (not display name) of the user you want to look for:

{{{ *[ResponsibleParties/ResponsibleParty/Persons/Person[@Name='demobob'] }}}

This will show all objects in metadata where demobob is present as one of the responsible parties (see below). Continue reading “Metacoda Plug-ins Tip: Find ResponsibleParty Objects for a User”

“How do I find all the private user folders for SAS users that have been deleted so I know which folders can be removed?”

I was asked this question recently and thought that I should be able to build up a single line XMLSELECT style SAS® metadata query to answer it. I could then paste this query in our free Metacoda Metadata Explorer Plug-in and export the results as a CSV file.

If you’re reading this post because that’s something you need to do, and you want the answer quickly, then here is the query:

{{{ Tree[@PublicType='Folder'][not(AssociatedIdentity/Person)][ParentTree/Tree[@Name='User Folders']/SoftwareComponents/SoftwareComponent[@PublicType='RootFolder']] }}}

The 3 curly brackets at the beginning and end are only needed if you are using the Metacoda Metadata Explorer Plug-in as it’s a signal that it is not a simple text search but an advanced XMLSELECT style query. If you are plugging this into some SAS PROC METADATA code then strip off the curly brackets.

If you want to know how that query works Continue reading “Finding Private User Folders for Deleted SAS Platform Users”