Custom report creation with multiple items

[MSnoob]

We have both versions of MS Office in our environment and getting ready to deploy Outlook, however we have older machines with 512MB RAM and a few that's below that. The problem is that I need to identify those machines with less than 512MB and Office 2003 and do it by location, there are 22 Distribution Points and would like to use those as the location.

 

I need to create this report that list the following items:

1. Machine name

2. Machine Type - Model

3. Amount of memory

4. Operating system - We have XP, Vista Business x64 and now a few Windows 7

5. Microsoft Office version (2003 and 2007)

6. Service Packs version for Office.

[Eswar Koneti]

Check it out : http://solodig.com/s...-customisations

or you can download the MOF file and import to your Reports Node:

Machines which are Lessthan 512 MB RAM.MOF.txt

Note :Remove .txt extesion before importing.

[MSnoob]

Check it out : http://solodig.com/s...-customisations

or you can download the MOF file and import to your Reports Node:

Machines which are Lessthan 512 MB RAM.MOF.txt

Note :Remove .txt extesion before importing.

 

 

This is what I'm looking for. Would it be possible to add the location using the info from the DP?

Thank you.

[wmmayms]

This is what I'm looking for. Would it be possible to add the location using the info from the DP?

Thank you.

 

Hm do you mean that you want to view that DPs that the clients used the last time? And with the help of that find out where they are located..

This could be a bit of a struggle and your sccm env would have to be using protected DPs for it to work (no fallback).

 

Maybe if you got the subnet of the client this would be enough? Or if this information is stored somewhere in the Active Directory (description?, OU?, AD Site?)? Maybe they are members of diffrent AD groups depending on location?

[MSnoob]

Check it out : http://solodig.com/s...-customisations

or you can download the MOF file and import to your Reports Node:

Machines which are Lessthan 512 MB RAM.MOF.txt

Note :Remove .txt extesion before importing.

 

Got a error message after importing the .MOF file and running it:

 

An error occurred when the report was run. The details are as follows:

Invalid column name 'Microsoft Office%'.

Error Number: -2147217900

Source: Microsoft OLE DB Provider for SQL Server

Native Error: 207

 

Fixed it by removing the "Double Quotes".

[MSnoob]

Hm do you mean that you want to view that DPs that the clients used the last time? And with the help of that find out where they are located..

This could be a bit of a struggle and your sccm env would have to be using protected DPs for it to work (no fallback).

 

Maybe if you got the subnet of the client this would be enough? Or if this information is stored somewhere in the Active Directory (description?, OU?, AD Site?)? Maybe they are members of diffrent AD groups depending on location?

 

The DPs are protected, however I can't use the subnet because there are multiple departments within that subnet that's in the DP. The problem is that we don't have a OU by location.