Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: owenhawk
  • Content: Threads
  • Order by date
  1. owenhawk

    How to display SMS query results in a SMS report

    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...
  2. owenhawk

    SMS Query to determine MDAC version

    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...
  3. owenhawk

    SMS report to list number of devices in a collection

    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...
  4. owenhawk

    SMS Report to list all apps in ARP for a Device minus certain apps

    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 =...

Part and Inventory Search

Back
Top