Re: Data Usage Auditing

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 14:29:46 -0800

The query log is NOT what you are looking for. It was designed exclusively
to be used as a data source for usage-based optimization. It is not a
general-purpose facility. Use it at your own risk. There is no guarantee
that every query is logged and if you look at the details you will see that
what is logged is really aggregate usage, i.e. the artifacts of a query; not
queries themselves.

Can you give us a sense of what kind of auditing? If it is just users coming
onto the system, then look at the AuditLogin registry documented here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"LP" <LP@discussions.microsoft.com> wrote in message
news:31C66EA6-6E1B-4BF0-BBC6-1915EF13F37D@microsoft.com...
> I'm starting to look at using a data warehouse and would like to have some
> tracking of the queries ran against the data warehouse.
>
> I've gone through several articles about the MS Access database
msmdqlog.mdb
> and I'm just looking for ways to implement the auditing and I have a few
> questions.
>
> I guess the easy thing is to generate reports from the Access database
using
> Access itself to help me figure out if who is looking at the data, how
long
> it takes the queries to run. But my real question is are there better
things
> to do with it.
>
> I read that it might be best to migrate the logging away from Access and
> into SQL Server directly but following that thought it lead me to some
horror
> stories about the many registry entries that need to be modified and the
> pains encountered when updating service packs and the like.  Seemed that
> Analysis Services was tied in many ways to the msmdqlog.mdb for this type
of
> auditing.
>
> I was also considering the possibility of creating a cube in the data
> warehouse based on the QueryLog table from the msmdqlog.mdb
>
> What are some of the prevailing ways to report on usage statistics from
> Analysis Services?
>
> Thanks for any help.
>
> Larry
>
>
>

Relevant Pages

  • Analysis Services Data Access Auditing with msmdqlog.mdb
    ... I’m starting to look at using a data warehouse and would like to have some ... tracking of the queries ran against the data warehouse. ... I’ve gone through several articles about the MS Access database msmdqlog.mdb ... Analysis Services was tied in many ways to the msmdqlog.mdb for this type of ...
    (microsoft.public.sqlserver.datawarehouse)
  • Data Usage Auditing
    ... I’m starting to look at using a data warehouse and would like to have some ... tracking of the queries ran against the data warehouse. ... I’ve gone through several articles about the MS Access database msmdqlog.mdb ... Analysis Services was tied in many ways to the msmdqlog.mdb for this type of ...
    (microsoft.public.sqlserver.olap)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Set daoDbs = Nothing ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)