How to report on MS Office

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

How to report on MS Office

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Networking & Security] >> GFI LANguard >> How to report on MS Office

Page: [1]

Message

<< Older Topic Newer Topic >>

How to report on MS Office - 4.Oct.2007 8:45:12 AM

tporcaro

Posts: 4
Joined: 4.Oct.2007
Status: offline

Is there an easy way to just report on how many pcs have MS office on it? We are looking to make sure we are in compliance and the reports i am generating are huge.

Post #: 1

RE: How to report on MS Office - 4.Oct.2007 11:08:28 AM

Maxtor

Posts: 64
Joined: 23.Sep.2003
From: California
Status: offline

You will need to run the "software audit" from Languard 8.0 then either use the Languard report center to create the report or you can run it in access as well. Is this just for office 2000 only?

(in reply to tporcaro)

Post #: 2

RE: How to report on MS Office - 4.Oct.2007 2:23:27 PM

tporcaro

Posts: 4
Joined: 4.Oct.2007
Status: offline

Its for Office 2003. I was hoping there was an easy way to trim down all the data it is returning. It is giving me all the software, even when i try to set up a custom filter.

(in reply to Maxtor)

Post #: 3

RE: How to report on MS Office - 4.Oct.2007 4:49:34 PM

Maxtor

Posts: 64
Joined: 23.Sep.2003
From: California
Status: offline

I found the report pack to be a bit clumsy also.. For best results, perform a query against your database using the following command in MS Access.

SELECT Scan.HostName, Scans.CreatedOn, AppsInstalled.AppName, AppsInstalled.AppVersion
FROM Scans INNER JOIN (Scan INNER JOIN AppsInstalled ON Scan.ScanID = AppsInstalled.ScanID) ON Scans.ScansID = Scan.ScansID
WHERE (((AppsInstalled.AppName) Like 'MicroSoft Office*'))
ORDER BY scan.hostname, scans.createdon;

(in reply to tporcaro)

Post #: 4

RE: How to report on MS Office - 4.Oct.2007 5:25:12 PM

tporcaro

Posts: 4
Joined: 4.Oct.2007
Status: offline

Will this query work for MS sql? I am running this on microsoft sql?

(in reply to Maxtor)

Post #: 5

RE: How to report on MS Office - 9.Oct.2007 12:41:16 PM

Maxtor

Posts: 64
Joined: 23.Sep.2003
From: California
Status: offline

Yes it will... I'm setup the same way. You just need to point Access to SQL using an ODBC connection.