User access monitor

Permalink · ‎2010-03-17

Hi.

We have now recently installed QV server/publisher 9.0 and are trying to tweak it to fit our organization. But we have on question that I guess everyone have faced during their distribution of Qlikview-files.

Is there a Monitor or other way where you easily can see access rights per Qlikview-file. For example if a user leaves the department I would like to easily see which files he had access to and remove those via the publisher. You could also use it see which files a user can see OR which users have access to this specific file.

The Operations Monitor only shows if a user has accessed the file.

Permalink · ‎2010-10-26

Hi Alex,

Thanks! i found it. but it's in xml.

I wrote the following for v8 with sql db, do u think i can still use the same? or i need to modify a bit?

Thanks.



SELECT
Recipient.XSName, SourceDocument.Name, DistributionTask.Name AS Expr1, conn_DT_Rec.ModifiedByUser, conn_DT_Rec.ModifiedTime,
DistributionTask.Enabled, conn_DT_Rec.CreatedByUser, conn_DT_Rec.CreatedTime
FROM
conn_DT_Rec INNER JOIN
DistributionTask ON conn_DT_Rec.DistributionTaskID = DistributionTask.ID INNER JOIN
Recipient ON conn_DT_Rec.RecipientID = Recipient.ID INNER JOIN
SourceDocument ON DistributionTask.SourceDocumentID = SourceDocument.ID
order by SourceDocument.Name

Permalink · ‎2010-10-27

Hi,

QVPR will not give the full listing of all files available in the mounted folders.

If the QVS uses "NTFS authorization" look for command line output of CACLS.exe (or simular tool with nicer output). If it uses the "DMS authorization", for each QVW file there should be one XML file with category name, recipients

-Alex

Permalink · ‎2010-10-28

Hi,

Found this script fragment for QV 8 QVPR in XML . By looking at recipients + distributiontasks and recipients + accesspoints you can stop distributing in future to people that left.

-Alex


AccessPointResource:
LOAD Path,
 AllowPluginClient,
 AllowJavaClient,
 AllowDownLoad,
 AllowZeroFootprintClient,
 //ZfcDocumentUrl,
 //ZfcFileUrl,
 AccessPointType,
 Inherit,
 //ScrambleFilename,
 FolderID,
 Url,
 //SendNotificationMail,
 //SMTPServerResourceID,
 Name as AccessPoint_Name,
 Description as AccessPoint_Description,
 ResourceType,
 IsDistributionResource,
 IsDirectoryResource,
 Enabled as AccessPoint_Enabled,
 ExecutionServiceResourceID as ExecutionServiceResourceID_2,
 ID as ResourceID
 //LockedByUser,
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/AccessPointResource]);



Category:
LOAD Name as Category_Name,
 Description as Category_Description,
 ID as CategoryID
 //LockedByUser,
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/Category]);

conn_DT_Cat:
LOAD DistributionTaskID as TaskID,
 CategoryID,
 ID as conn_DT_Cat_ID
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/conn_DT_Cat]);

///////////////

conn_DT_Res:
LOAD DistributionTaskID as TaskID,
 ResourceID,
 ID as conn_DT_ResID
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/conn_DT_Res]);



conn_DT_Rec:
LOAD DistributionTaskID as TaskID,
 RecipientID,
 ID as conn_DT_RecID
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/conn_DT_Rec]);



Job:
LOAD Name as Job_Name,
 Enabled as Job_Enabled,
 Description as Job_Description,
 Timeout,
 SendAlertEmail,
 //RetryCount,
 //RetryDelaySeconds,
 //MailSendMode,
 //MailSendTimes,
 //MailUseSendTime,
 //MailSendTime,
 EDXPassword,
 ExecutionServiceResourceID as ExecutionServiceResourceID_3,
 ID as JobID
 //LockedByUser,
 //LockedUntil,
 //ModifiedByUser,
 //ModifiedTime,
 //CreatedByUser,
 //CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/Job]);



Task:
LOAD Name as Task_Name,
 Enabled as Task_Enabled,
 Description as Task_Description,
 TaskType,
 ExecutionServiceResourceID as ExecutionServiceResourceID_4,
 ID as TaskID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/Task]);



Recipient:
LOAD XSRecipientID,
 XSName as RecipientName,
 ExecutionServiceResourceID as ExecutionServiceResourceID_1,
 DSObjectType,
 ID as RecipientID
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/Recipient]);


conn_Job_Task:
LOAD JobID,
 TaskID,
 RunOrder,
 //Timeout,
 ID as conn_Job_Task
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/conn_Job_Task]);



StartBlock:
LOAD JobID,
 Enabled,
 EnableDateTime,
 ExpireDateTime,
 RecurrenceType,
 RepeatEvery,
 HourStart,
 DayStart,
 RepeatMaxCount,
 ID as StartBlockID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/StartBlock]);

ExternalProgramTask:
LOAD CommandLine,
 Name as ExternalProgramTask_Name,
 Enabled as ExternalProgramTask_Enabled,
 Description as ExternalProgramTask_Description,
 TaskType as Ext_TaskType,
 ExecutionServiceResourceID as ExecutionServiceResourceID_8,
 ID as TaskID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/ExternalProgramTask]);


ReloadTask:
LOAD UsePartialReload,
 SectionAccessUserName,
 SectionAccessPassword,
 OverrideXSSectionAccess,
 Name as ReloadTask_Name,
 Enabled as ReloadTask_Enabled,
 Description as ReloadTask_Description,
 TaskType as Reload_TaskType,
 ExecutionServiceResourceID as ExecutionServiceResourceID_10,
 ID as TaskID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/ReloadTask]);


DistributionTask:
LOAD AllowAccesspointDistribution as DT_AllowAccesspointDistribution,
 AllowMailAttachmentDistribution as DT_AllowMailAttachmentDistribution,
 AllowFolderDistribution as DT_AllowFolderDistribution,
 AllowQVSDistribution as DT_AllowQVSDistribution,
 AllowPluginClient as DT_AllowPluginClient,
 AllowJavaClient as DT_AllowJavaClient,
 AllowDownloadClient as DT_AllowDownloadClient,
 AllowZeroFootprintClient as DT_AllowZeroFootprintClient,
 AlwaysOpenable,
 SourceDocumentID,
 ClearLocks,
 ClearAll,
 ClearAlwaysOneSelected,
 ReapplySelections,
 SetScript,
 DDDField,
 DDDValueType,
 SectionAccessUserName as DT_SectionAccessUserName,
 SectionAccessPassword as DT_SectionAccessPassword,
 OverrideXSSectionAccess as DT_OverrideXSSectionAccess,
 MaxOpenSessions,
 AutoLoadMode,
 AutoLoadFromTime,
 AutoLoadToTime,
 AutoLoadDayOfWeek,
 ShowToolbar,
 GenerateHTMLFiles,
 Name as DT_Name,
 Enabled as DT_Enabled,
 Description as DT_Description,
 TaskType as DT_TaskType,
 ExecutionServiceResourceID as ExecutionServiceResourceID_20,
 ID as TaskID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/DistributionTask]);


RepeatTask:
LOAD LoopType,
 "From" as RT_From,
 To,
 Name as RT_Name,
 Enabled as RT_Enabled,
 TaskType as RT_TaskType,
 ExecutionServiceResourceID as ExecutionServiceResourceID_30,
 ID as RT_ID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/RepeatTask]);

//not exactly like this ..
rem conn_RepT_Task:
LOAD RepeatTaskID as RT_ID,
 TaskID,
 RunOrder as RepT_RunOrder,
 ID as RepT_ID
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/conn_RepT_Task]);


Trigger_Task:
LOAD [TriggerEDXTask/XSID] as XSID,
 [TriggerEDXTask/XSUrl] as XSUrl,
 [TriggerEDXTask/JobIdentifier] as JobIdentifier,
 [TriggerEDXTask/QueueIfAlreadyRunning] as QueueIfAlreadyRunning,
 [TriggerEDXTask/Name] as Trigger_Task_Name,
 [TriggerEDXTask/Enabled] as Trigger_Task_Enabled,
 [TriggerEDXTask/TaskType] as Trigger_Task_TaskType,
 [TriggerEDXTask/ExecutionServiceResourceID] as ExecutionServiceResourceID_40,
 [TriggerEDXTask/ID] as TaskID
FROM  (XmlSimple, Table is [NewDataSet]);
// End of [TriggerEDXTask.xml] LOAD statements


Trigered_Job:
LOAD Name as Trigered_Job_Name,
 ID as JobIdentifier
FROM  (XmlSimple, Table is [NewDataSet/Job]);


SourceDocumentFolderResource:
LOAD Path as SDF_Path,
 EnableSubFolders,
 Name as SDF_Name,
 Description as SDF_Description,
 ResourceType as SDF_ResourceType,
 IsDistributionResource as SDF_IsDistributionResource,
 IsDirectoryResource as SDF_IsDirectoryResource,
 Enabled as SDF_Enabled,
 ExecutionServiceResourceID as ExecutionServiceResourceID_50,
 ID as SDF_ID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/SourceDocumentFolderResource]);


SourceDocument:
LOAD XSDocumentID as SD_XSDocumentID,
 Name as SD_Name,
 Path as SD_Path,
 FolderID as SDF_ID,
 Enabled as SD_Rnabled,
 Description as SD_Description,
 ExecutionServiceResourceID as SD_ExecutionServiceResourceID,
 ID as SourceDocumentID
// LockedByUser,
// LockedUntil,
// ModifiedByUser,
// ModifiedTime,
// CreatedByUser,
// CreatedTime
FROM  (XmlSimple, Table is [NewDataSet/SourceDocument]);

Related Topics