Search results for query: *

I have some very nice SMS queries that I want to display in SMS reports. I notice that you have to convert alot of the code to get this to work. I see a view in SMS reports called v_Query and I thought it might be used to display the results of a already created SMS query. Is anyone familiar...

Thank you both for your suggestions, unfortunately I don't think MDAC is tracked by SMS as a product. I don't see anything with MDAC listed in any of our SMS reports. I think that is why MS provides the Component Checker because you have evaluate many dlls to know what true version of MDAC you...

Can an SMS query be configured to report the version of MDAC on a device? My initial thought is no, since I can not find any hits on this subject. I know about the MS MDAC component checker program which I guess I could push down to a device and run and then analyze the file export, but first I...

The first sql code worked for all devices. I am trying the specfic collection suggestion, doesn;t cooperate yet. Ill keep trying. Thank you very much.

When I run the report to display all devices in a collection, in the upper right corner is the number of devices that are listed below. I want to just display the number of devices. I have a report that displays just the number of devices that have a certain app in ARP, but now I want to...

My SMS came with a report to list all devices in a collection as follows: FROM v_FullCollectionMembership WHERE CollectionID = "SMS000ES" ORDER BY Name But I want the report to list just the number of devices in the collection. There are only 2 canned reports that come with SMS...

Usually there are switches to take to make uninstalls silent, but in case where this is not possible, we've put a wrapper program, usually written in WinBatch, around the uninstall that puts a banner on part of the screen or even the entire screen. WB can be told that the banner has priority can...

Thank you all for the assistance. The code to list all ARP on a device minus certain exceptions (like security updates in this example) as follows: Select v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS JOIN v_R_System ON v_GS_ADD_REMOVE_PROGRAMS.ResourceID =...

I am new to SMS reports. This default report to list all ARP on a certain device came with our SMS: Select v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS JOIN v_R_System ON v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_R_System.ResourceID WHERE v_R_System.Netbios_Name0 =...