|
|
OWSUG
-
|
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as...
|
-
|
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer'...
|
-
|
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer'...
|
-
|
Use this query to find all webcam – SQL reports select CS.Name0, SD.Name0, SD.DeviceID0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SYSTEM_DEVICES SD on CS.ResourceID = SD.ResourceID Where SD.Name0 like '%Webcam%'...
|
-
|
Use this WQL query to find all webcam http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/fa5fcfe2-69ef-4482-adfc-de25d6d19669/?prof=required select SMS_R_System.Name, SMS_G_System_SYSTEM_DEVICES.Name, SMS_G_System_SYSTEM_DEVICES.DeviceID...
|
-
|
If you need to find all PC within an AD container (not an OU). Use this WQL query to find them. For more details about this request, see the full forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/9358cee7-75a5-4595-80a3-4016ea572f1b...
|
-
|
For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=238953&mpage=1#239186 SELECT distinct sys1.Name0, csys.Model0, csys.Manufacturer0, os.Caption0, os.CSDVersion0, BIOS.SerialNumber0, sys1.description0, REPLACE(( SELECT IPAddress0...
|
-
|
For full details please see: http://social.technet.microsoft.com/Forums/en-ca/configmgrreporting/thread/19e0771c-eddc-43f7-956c-a5c9f0110e59 SELECT A.Name0, B.SerialNumber0 , A.Manufacturer0,...
|
-
|
For full details, please see http://social.technet.microsoft.com/Forums/en-ca/configmgrai/thread/7951b781-8354-490b-9b59-4fe4e68d1975 SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15'...
|
-
|
SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21' ) THEN 'Laptop'...
|
-
|
For full details please see http://www.myitforum.com/Forums/tm.aspx?m=238674&high = SELECT distinct DisplayName0, Count (arp.ResourceID) AS 'Count' , Publisher0, @CollID as CollectionID FROM dbo.v_Add_Remove_Programs arp JOIN dbo.v_FullCollectionMembership...
|
-
|
For full details, please see http://www.windows-noob.com/forums/index.php?/topic/7308-collection-membership/#entry27677 select C.Name from dbo.v_FullCollectionMembership FCM join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where FCM.Name =...
|
-
|
For full details, please see http://www.myitforum.com/forums/Active-Directory-Discovery-additional-Attributes-and-broken-reports-and-queries-m238462.aspx select distinct R.ResourceID, R.Name0, R.Client0, BIOS.SerialNumber0 from dbo.v_R_System AS R LEFT...
|
-
|
For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/fde395bb-a4b6-4347-b1b6-8c180c3f7f46 This is a WMI WQL query and NOT and native CM07 / CM12 WQL query. select Size from Win32_LogicalDisk Where...
|
-
|
For Full detail see http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/547016e0-9f15-4611-aac9-24f582aa0614 select R.netbios_name0, R.user_name0, OS.Caption0 AS 'Operating System' , ES.SerialNumber0 AS 'Serial...
|
-
|
For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/2f072158-88c2-48e9-8125-2e137494fbeb select Creation_Date0, Name0, User_Name0 from dbo.v_R_System where datediff(dd,Creation_Date0, getdate()) < 14...
|
-
|
For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM...
|
-
|
For full detail , please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/688bff46-a0ed-44cb-84c2-df036fe40e84 select SF.* from dbo.v_GS_SoftwareFile SF Where FileName not in ( 'sol.exe' , 'freecell.exe' )...
|
-
|
If you are trying to install CM12 console on a workstation, you will receive the following error: Input string was not in a correct format . The solution is to browse the DVD and smssetup\bin\i386 and execute the AdminConsole.msi....
|
-
|
I’m back at working on my exams again! This time I passed this exam on Thursday morning. I also passed my ITIL exam a while back too. I notice that I never posted anything about it. ;-) Anyways. Since Windows Server 2012 and Windows 8 has been...
|
-
|
For full details please see: http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx SELECT DISTINCT CS.Name0 as 'PC' , '' as 'Blank column1' , BIOS.SerialNumber0 as 'SN #' , CS.Manufacturer0 as 'Manufacturer'...
|
-
|
For full details see: http://www.windows-noob.com/forums/index.php?/topic/7022-last-logged-user/ Select R.Netbios_Name0, R.User_Domain0 + '\' + R.User_Name0, CS.UserName0 from dbo.v_R_System R join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID...
|
-
|
For full detail see. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/32c4db2f-ae84-4fed-93c1-c3f35f8a6fff I liked this request, I might ever try to make an NICE SSRS report out of this one. But not for a few weeks,...
|
-
|
For full details please see: http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/107d690a-4bbd-49c4-87bf-389278525b63 select distinct R.ResourceID, R.User_Name0, R.Netbios_Name0 AS 'Computer_Name' , R.Resource_Domain_OR_Workgr0...
|
-
|
For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R join dbo.v_RA_System_MACAddresses MAC ON R.ResourceID...
|
|
|
|