Reporting from Web Interface

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Reporting from Web Interface

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Reporting from Web Interface

Page: [1]

Message

<< Older Topic Newer Topic >>

Reporting from Web Interface - 5/23/2008 11:02:08 AM

adamdaviddoyle

Posts: 22
Score: 0
Joined: 3/6/2008
Status: offline

Visiting my web list of reports for my CCM box. Whenever i run reports w/ PCs i get duplicates for each machine? Is there a way to stop that?

Post #: 1

RE: Reporting from Web Interface - 5/23/2008 3:17:41 PM

jnelson993

Posts: 722
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

It depends on the report and what the SQL query is. There are many reasons why a report would show duplicates. Could you be more specific and give us some code :)

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to adamdaviddoyle)

Post #: 2

RE: Reporting from Web Interface - 5/27/2008 8:21:37 AM

adamdaviddoyle

Posts: 22
Score: 0
Joined: 3/6/2008
Status: offline

Report Name:
Computers with specific software registered in Add Remove Programs

Category:
Software - Companies and Products

Comment:
Displays a summary of all computers with specific software registered in Add Remove Programs

Parameters:

Software Title
Microsoft Office Enterprise 2007

Collection ID
SMS000ES

Just one of the pre-loaded reports and seeing how many instances of Office 2007 we have installed.

(in reply to jnelson993)

Post #: 3

RE: Reporting from Web Interface - 5/27/2008 11:27:50 AM

jnelson993

Posts: 722
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Well, something that report is going to show you is all of the installed pieces of software that match the parameters you put into it. So if you enter something broad like Microsoft Office% then it will return all of the separate entries for each machine that match that string...it doesn't just count one machine per match.

Microsoft Office Professional 2007
Microsoft Office Outlook 2007
Microsoft Office Outlook Connector
Microsoft Office Visio Professional 2007
...
they would ALL match your criteria.

So, the way to stop that is to make your parameters more specific. If you're looking for Office Professional 2007, put in

Microsoft Office Professional 2007

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to adamdaviddoyle)

Post #: 4

RE: Reporting from Web Interface - 5/27/2008 1:21:36 PM

adamdaviddoyle

Posts: 22
Score: 0
Joined: 3/6/2008
Status: offline

That's how i'm doing it actually,

I'm specifying "Microsoft Office Enterprise 2007" (that's the version we are installing)

And it's still showing duplicates of every single PC.

(in reply to adamdaviddoyle)

Post #: 5

RE: Reporting from Web Interface - 6/9/2008 2:21:03 PM

jnelson993

Posts: 722
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

http://www.myitforum.com/forums/m_180484/mpage_1/key_/tm.htm#180529

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to adamdaviddoyle)

Post #: 6