Re: Server files - Qlik Community

Masajnik · ‎2019-06-26

Do they know something about to get server information, for example, windows user group/ users/Files etc, most important for me is... what group of windows does a file belong to?

Sonja_Bauernfeind · ‎2019-06-27

Hello,

The community would need a little more information about your request to be able to help.

What sort of Server files are you looking for? Server installation files? Configuration files? Or QlikView documents hosted on the server?

/Sonja

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂

Masajnik · ‎2019-06-27

Hi Thank for the anwer , I need QlikView documents hosted on the server,
the qvw aplications with Windows group of this qvw

Masajnik · ‎2019-06-28

Buen dia, lo que estoy necesitando es el grupo de windows que esta relacionado al archivo qvw, eso se puede hacer ?

Masajnik · ‎2019-06-28

¿Saben algo sobre cómo obtener información del servidor, por ejemplo, grupo de usuarios de Windows / usuarios / Archivos, etc.? Lo más importante para mí es ... ¿a qué grupo de windows pertenece un archivo?

Sonja_Bauernfeind · ‎2019-06-28

As you are looking for information on what Windows Groups have access to what Files, it'd be best to use Windows tools for this, which is not something Qlik can help you with. So you'd be looking for a command line that lists files and their permissions (access), or other third party tools.

Based on this, I'm assuming that you are using NTFS, not DMS. In this case, QlikView relies on the Windows system's setup when you are using NTFS, so I'd suggest getting it directly from there.

From QlikView's side you can scan for activity on files by scanning the log files for open actions from users. That will tell you what users are opening documents, but it doesn't seem like this is what you are looking for.

If you are using a QlikView Publisher, then you have Distributions set up, and the distribution tasks will also include the groups in there. But again, that is still approaching it from the wrong side, I think, and sticking with Windows to find that information is probably going to be easier than pulling the Distribution information (groups) out of the QVPR.

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂

Masajnik · ‎2019-06-28

Thank you!

Do you know to do that?

"going to be easier than pulling the Distribution information (groups) out of the QVPR"

Sonja_Bauernfeind · ‎2019-07-02

If you are using NTFS (windows file access is governing access), then I really advise you use the correct tool for the job of listening that, meaning: Windows.

Looking up what Distributions are set up does not exactly equal what user documents you have and can get complicated if you have loops and reductions creating multiple documents out of a single one, etc. Again, using Windows tools on the actual User Documents is what you want to be doing.

The Distribution Groups configured can be seen in the QlikView Management Console: Source Documents > The Document of your choice > Distribution > Manual > Recipients (far right).

This is also stored in an .xml file found in: C:\ProgramData\QlikTech\ManagementService\QVPR call DistributionDetail.xml for each TASK (again, that does not mean it corresponds to your User Documents). You would need to parse the document ID as well, figure out what name it has, since the content of the file looks like this:

As you can see, no real information on what document you get. Neither if those are still being executed to run new tasks, so there might not even be documents related to this right now.

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂