Reporting

36 Topics

Reporting on user fails to bulk add users in Data Insight
When testing addition in the lab where I would have User1@productionand User1@Labthe user fails to add as unable to resolve: 2023-10-26 14:29:39 WARNING: #{421} [ServerUtils.getUserByLogonName] Unable to resolve user Java.lang.Exception: Unable to resolve user at com.symc.matrix.ui.server.ServerUtils.getUserByLogonName(ServerUtils.java:462) at com.symc.matrix.ui.server.ServerUtils.getUserByLogonName(ServerUtils.java:449) at com.symc.matrix.report.util.ReportsUtils.getUsers(ReportsUtils.java:6559) at com.symc.matrix.report.util.ReportsUtils.setCSVValues(ReportsUtils.java:7912) at com.symc.matrix.ui.server.servlets.FileUploadServlet.processReportsCsv(FileUploadServlet.java:776) at com.symc.matrix.ui.server.servlets.FileUploadServlet.processUpload(FileUploadServlet.java:264) at com.symc.matrix.ui.server.servlets.FileUploadServlet.doPost(FileUploadServlet.java:173) at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.symc.matrix.ui.server.filters.LoginFilter.doFilter(LoginFilter.java:110) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.symc.matrix.ui.server.filters.CacheControlFilter.doFilter(CacheControlFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2023-10-26 14:29:39 WARNING: #{421} [ReportsUtils.getUsers] Not able to resolve user/group However if I type in the string used and filter both are returned. Is there a flag to add all found users? Is this a bug or assumption that a large enterprise does not have >1 user with the same name? Is there a known workaround to add the users to the report in bulk? Pix
Pix_R
9 months ago Place Data Insight
939Views
0likes
1Comment
Data Aging report bucket size
I am attempting to edit the bucket size for a data aging report. The default is 48 months but I would like to runreports where the bucket size is 24 and 36 months.
Solved
drahrig
8 years ago Place Data Insight
1.8KViews
0likes
3Comments
Data Insight - report.exe
Hello, I seem to be having an issue running the data againg report within Data Insight. Every time I run this report it fails. I had a call with tech support and they mentioned the report.exe keeps crashing. They are currently looking into it, but I wanted to reach out to see if anyone else is has has this issue in the past. Thanks
ikestew2002
8 years ago Place Data Insight
659Views
0likes
1Comment
DQL Report does not output to 1 file 5.0.1
I am using DI 5.0.1 and I am not able to have the DQL report to output to 1 single file. Is anyone else having this issue? I have a DQL query and when I am pulling some of the AD Attributes, it will separate the files. I even have put 'format user AS csv' at the end and it still puts it into multiple files. From user get name, principal_name, login, Home_directory, Department If Home_Directory not in ('nowhere') format user AS CSV; Please help!
DLP_Solutions2
9 years ago Place Data Insight
3.2KViews
1like
3Comments
How to change report schedule on mass ?
Hi, I have a Data insight 5.0 system with several hundred scheduled reports whichwe need to change the time that they run. Is there a way of changing the report schedules on mass via the command line, i.e. reportcli or sqlite; or do we needto editthe schedule for each reportindividually through the GUI? Kind regards Philip
Phil_Rosier
9 years ago Place Data Insight
1.5KViews
1like
1Comment
Report of Data Insight Users
Hi, Apology this question is related to internal tables rather than DQL, but hopefully someone on here may be able to help. I need to create an automated report or script that captures a list of the Data Insight users and their respective roles to enable regular reviews of who has access to the data insight console. We currently have a manual process using the GUI, but need to move to an unattended solution that captures this information, merges it with other records and submits the final report to an access management system where access to the Data insight console is reviewed and if necessary revoked. Data Insight config.db has a table called “matrixuser” which contains details of the user accounts such as thier login and domain names, and a table called “role” which contains details of all the roles that are available in Data Insight --- but I can’t find anything that shows which users have been assigned to which roles. Does anyone know how or where to find this Kind regards Phil.
Solved
Phil_Rosier
9 years ago Place Data Insight
2.9KViews
1like
5Comments
Data Insight Policies and Alerts
I have a client that would like to be notified if a user attempts to access files or folders to which they shouldn't have access. Now, this should not be an issue at all if file and folder ACLs are correct but that's another story. So, assuming a user doesn't have read access but can view files and folders can SDI provide alerts for this attempted access? Can the Widows File Server agent even track unsuccessful access attempts?The client is after real time alerting, if possible. I've had a look at reports but there doesn't seem to be anything useful so I thought policies may be the way to go.Has anyone got whitelist or blacklist policies to work? The documentation goes on about custom AD attributes and such but gives no information about how one would actually use them. I've asked Symantec for examples but I received nothing useful. Thanks Mark
markr1963-2
9 years ago Place Data Insight
882Views
0likes
1Comment
DQL report problem
I am attempting to create a Sensitive files with violated policies report from the template. I have uploaded a .csv with the policies named, however when the report run and I look at the output, no policy is listed. I have included the script, any suggestions? FROM path GET device.name, msu.name, absname, activity_count, dlp_policies IF issensitive=1 AND path.msu.name = "xxx" path.msu.name = "yyy" path.msu.name = "zzz" FORMAT dlp_policies AS CSV;
Solved
drahrig
9 years ago Place Data Insight
2.1KViews
2likes
10Comments
DQL - Bulk input of search paths
Hi, I have a report which searches a list of pathsfor certain types of files such as vmdk, for example. FROM dfspath GET absname IF extension = 'vmdk' AND (substri(dfspath.absname, '<search path1>')=1 OR substri(dfspath.absname, '<search path2>')=1) Is there a way to read in the list of search paths from a CSV file rather than hard-coding them into the report. I tried using the IN FILE expression but this looks for a exact match of the pathnames whereas we are search for files below these paths. Alternatively, does DQL support wild characters such as '*' or '%' Any advice is much appreciated as always. Phil
Phil_Rosier
9 years ago Place Data Insight
1.3KViews
0likes
1Comment
DQL report assistance
I am trying to create a custom DQL report with the details below but I need to search our file servers over a specific date range and can't work out how to specify this. can anyone assist? FROM path Get name, basename, absname, created_on, active_users.name If matchi(basename,’"*John.Doe*")=1 OR matchi(basename,"*Address")=1 OR matchi(basename,"*Address varient*")=1 Much appreciated in advance
Smudgers9
9 years ago Place Data Insight
935Views
0likes
1Comment