I have some users connecting to the cubes using excel, is there any way i can track which users aere connected to the cubes without using the Profiler/running a trace.
You can do an XMLA discover command to discover the current sessions/connections
<Discover xmlns="urnchemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_SESSIONS</RequestType>
<Restrictions>
<RestrictionList />
</Restrictions>
<Properties>
<PropertyList />
</Properties>
</Discover>
<Discover xmlns="urnchemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_CONNECTIONS</RequestType>
<Restrictions>
<RestrictionList />
</Restrictions>
<Properties>
<PropertyList />
</Properties>
</Discover>
But I think that the easiest way to run these commands is to use the Analysis Services Stored Procedure Project www.codeplex.com/asstoredprocedures where you can do the equivalent and get the results in an easy to read table form by doing
CALL ASSP.DiscoverSessions();
or
CALL ASSP.DiscoverConnections();
There was also an AMO Activity sample (or something like that) in the Analysis Services product samples that could show this sort of information.
No comments:
Post a Comment