SCCM Queries for Microsoft Visio Standard or Professional

sccmsccm-2012

I am after a query that will show me whether workstation have a professional or standard version of an office product like visio 2010.

I have the following which I have found on here, but can not tweak it to show that, not very good with queries in SCCM at the moment.

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName
from SMS_R_System
inner join SMS_G_System_ADD_REMOVE_PROGRAMS on
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Standard%"
or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Professional%"
order by SMS_R_System.Name

Updated the query and got it working how I like now. Run this against all active computers and it will return what version they have Professional or Standard.

Best Answer

This worked for me:

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 
from  SMS_R_System 
inner join SMS_G_System_ADD_REMOVE_PROGRAMS 
   on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID =   SMS_R_System.ResourceId 
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Standard%" 
   or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Professional%" 
order by SMS_R_System.Name

Related Solutions

SCCM Report to identify machines with 64-bit capable hardware

I had a feeling that posting on here would be what made me find the actual answer myself!

Have found a property of the system processor that seems to answer the question exactly right on all OS's I've tested with (server & workstation from XP/2003 up). What I have is v_GS_PROCESSOR.Is64Bit0 which gives a 1 or a 0 depending on whether or not the CPU is 64-bit capable.

My SCCM queries now are (for a top-down summary):

select
    OS.Caption0,
    case when pr.Is64Bit0=1 then '64-bit'
    when pr.Is64Bit0=0 then '32-bit'
    end as [Processor Type],
    Count(*)
from
    dbo.v_gs_processor PR Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on PR.ResourceID = OS.ResourceId
Group by
    OS.Caption0,
    pr.Is64Bit0
Order by
    OS.Caption0,
    pr.Is64Bit0

And (for the machine by machine listing):

select sys.netbios_name0, sys.Operating_System_Name_and0 as OperatingSystem, 
case when pr.Is64Bit0=1 then 'Yes 64-bit'
when pr.Is64Bit0=0 then 'No 32-bit'
end as [Processor Is 64-Bit?],
case when pr.addresswidth0=64 then '64-bit OS'
when pr.addresswidth0=32 then '32-bit OS'
end as [Operating System Type],
case when pr.DataWidth0=64 then '64-bit Processor'
when pr.DataWidth0=32 then '32-bit Processor'
end as [Processor Type (XP Lies)],
case when pr.addresswidth0=32 and pr.Is64Bit0=1 then 'YES'
end as [32-bit OS on x64 processor]
from v_r_system sys
join v_gs_processor pr on sys.resourceid=pr.resourceid

SCCM – Is It Overkill for Medium-Sized Organizations?

I would not call 800+ computers "mid sized". I was successfully deploying the successor of SCCM in a bank with 850 employees. In your case it is a lot more likely nowt knowing your tools that will be the problem - somehow I have a problem imagining the team of 3 people in a school being the highly competent people that companies employ for a lot more money. The learning curve WILL be brutal for you.

But once you are over it, it will help a lot - the whole System Center suite. 800+ machines is WAY too big to run around to install stuff.

Best Answer

Related Solutions

SCCM Report to identify machines with 64-bit capable hardware

SCCM – Is It Overkill for Medium-Sized Organizations?

Related Topic