|
Browse by Tags
All Tags » SQL ( RSS)
-
|
select * from dbo.v_GS_COMPUTER_SYSTEM where name0 like '___m%'
|
-
|
select DisplayName0, Version0, Count(*) From dbo.v_Add_Remove_Programs ARP Where DisplayName0 like '%office%' Group by DisplayName0...
|
-
|
SELECT Distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, ...
|
-
|
With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know...
|
-
|
SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 , OS . Caption0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID INNER JOIN dbo . v_GS_OPERATING_SYSTEM OS ON OS . ResourceID = ARP . ResourceID...
|
-
|
SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID Inner Join dbo . v_FullCollectionMembership FCM ON R . ResourceID = FCM . ResourceID...
|
-
|
Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”. Select ...
|
-
|
SELECT R.Netbios_Name0, os.Caption0, ARP.DisplayName0 As 'Softwarename', ARP.Publisher0 as 'Publisher', ARP.Version0...
|
-
|
select CS . name0 as 'PC name' , WS . LastHWScan as 'Last HW scan Date' from dbo . v_GS_COMPUTER_SYSTEM...
|
-
|
Quick follow up to How to Perform a Basic Software Audit Do you want to know how many ARP entries you have? How many page of paper you will get if you print all of the entries? What about bundles of paper? Use this query to help you determine this...
|
-
|
select FCM.CollectionId, C.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where R.Name0 = 'ES-03'
|
-
|
SELECT Distinct v.Name, CASE WHEN v.ResourceType = 3 THEN '*' ELSE '' END as C066, CASE WHEN v.ResourceType = 4 THEN '*' ELSE '' END as C067, ...
|
-
|
Topic: How to protect SQL Server using Microsoft System Center Data Protection Manager 2007 SP1 (DPM). Through discussions and demonstrations, we will be covering how DPM offers a continuous data protection for SQL Server with simple and advance...
|
-
|
select distinct CS.Name0, HARP.* from dbo.v_HS_ADD_REMOVE_PROGRAMS HARP join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = HARP.ResourceID join dbo.v_GS_COMPUTER_SYSTEM...
|
-
|
SELECT v_BoundaryInfo.SiteCode, V_ADD_REMOVE_PROGRAMS.DisplayName0, Count(*) FROM v_R_System_valid, v_BoundaryInfo, V_ADD_REMOVE_PROGRAMS...
|
More Posts Next page »
|
|
|