11-28-2017 04:54 AM
I can not find a method to create a report that can show either the files and path of folders that include particular TAGs.
I would like to be able to create a report that allows selecting a Filer and then finding all folders or files & path that have, say the UK-Passport Tagged.
Cheers
Chris
11-28-2017 09:17 AM
Chris, I believe the ask to be how to query tags using a equivalent match versus say all tags. We know that tags are a result of classification and meeting a specific policy that then 'tagged' the file with a remnant defined in the policy. Multiple tags could be assessed were it true that multiple policies triggered on the object which then assigns a tag to the path..
We know you can verify a tag in the workspace:
To review the tags assigned to file paths:
a. Navigate to the Workspace > Shares view.
b. Select the appropriate share.
c. In the right pane, on the Summary panel, expand the Tags section.
The tags assigned to the files under the shares are listed.
d. Use Workspace filters to search for files with specific tags and perform remediation actions.
That will provide you a quick and easy mechanism to find the tags you are interested in and double check they exist.
I also take it you are searching the reports that are canned or come with the product but are you aware that we have templates you can customize?
Another option is to run a Data Insight Query Language (DQL) report to review the tags assigned to the files submitted for classification.
As example the OLH (OnLine Help) does provide detailed steps and explanations in some of the areas you are pursuing; a good starting point when run on the Management Server (MS) itself or a browser with access to the MS and its' name replacing localhost < https://localhost/symhelp/ShowInTab?locale=EN_US&vid=v125236158_v125239294&ProdId=DISYMHELPV_6_1_CG >. This is a good starting point to modify the existing query for your use.
Note: the forums have a lot of detail on DQL, its use and the specific 'views' available. The manual also ships with the installation media as the SDK / Programmer's Guide.
Your goal seems to be filtering data via the DQL report to meet your criteria. If we chose the 2nd template listed the default choice would be:
Template 2: Get PST files with PII information
/*
Template1
Find PST files with PII
The path object gives various attributes of path
path.device.name would give the filer name (web app name when share point will be supported)
path.msu.name would give the share name
absname gives the full path of the file
name will give the path of file inside a share
path.basename will give just the filename
path.extension gives the extension of the file
tags are associated to file paths.
tags.name will give the name of the tag associated to the file path. There could be multiple tags for a given path.
The path table in output database has path_rowid which is used as a foreign key in tags table.
tags table also has the path_rowid
*/
FROM path
GET path.device.name,path.msu.name,type,absname,name,path.basename,tags.name
IF type='FILE' and extension='PST' AND tags.name='US-PII'
/* Advance SQL */
create table pathtag as select absname as pathname,tags_name as tag from path,tags where path.path_rowid=tags.path_rowid
Your modification might look something like:
FROM path
GET path.device.name,path.msu.name,absname,name,path.basename,tags.name
IF device.name='Filer' AND tags.name='UK-Passport'
Feel free to start there and customize to your desires.
I hope that is of use to you.
Rod
12-12-2017 06:29 AM
Hi Rod,
I don't see the PST Template.
But where do I put the modification?
FROM path
GET path.device.name,path.msu.name,absname,name,path.basename,tags.name
IF device.name='Filer' AND tags.name='UK-Passport'
In the DQL Query?
Also, now do i target a specific Filer?
12-12-2017 07:15 AM
Hello Chris,
Our templates are version specific. You can safely assume the newer the version the greater the number of templates. As example in version 5.2 we have:
whereas in 6.1 names have changed to:
I probably should have referred you to the PII (Personally Identifiable Information) template as you are likely running the latest. Sorry about that screenshots come from the lab I am running at the time and I am sure you can understand these change practically daily.
As to how to filter down further to a device or even a share you would need to add an additional to the WHERE clause in your report.
example for the filer device use
AND path.device.name='<Filer name>'
and to filter at the share level use
AND path.msu.name IN ('<ShareName>')
These do assume you have gotten these values with your get statement.
In the statement about we use an IF statement and you need to change 'filer' to the device's name under
IF device.name='Filer'
Rod
NOTE: The bolded values do need to be changed to a valid match.
07-09-2019 08:35 AM
Sorry, I know this thread is pretty old. I'm trying to filter the output based on absname where absname = '\\filer\directory\subdirectory" rather than the entire msu.name share. Is there a good way of doing that? I don't need the entire share.
07-09-2019 12:24 PM
Hi
Simplest way would be to add an additional conditional clause into your IF or WHERE statement like this:
AND substri(path.absname, "\\filer\directory\subdirectory") = 1
The substri function returns true (1) if the second string is contained within the first – the match being case insensitive (there is also a substr command if you are confident on the capitalisation of the absname path).
Cheers
David