There are cases,where a computer might be added to different collection and it would be difficult to find out the computer is member of which collections.Try this report to list all the collection the computer member of. select a.CollectionId, b.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership a on R.ResourceID = a.ResourceID join dbo.v_Collection b on b.CollectionID = a.CollectionID Where R.Name0 =@machine Prompt for machine: select Name0 from v_R_System If you want to try for user member of What collection ? below is the SQL report. select a.CollectionId, b.Name from dbo.v_R_User R join dbo.v_FullCollectionMembership a on R.ResourceID = a.ResourceID join dbo.v_Collection…
Author: Eswar Koneti
select Distinct CS.Name0, SER.Displayname0, SER.Started0, SER.StartMode0, SER.State0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SERVICE SER, dbo.v_FullCollectionMembership FCM where CS.ResourceId = SER.ResourceID and CS.ResourceId = FCM.ResourceID and SER.displayname0 like ‘%firewall%’ and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”) and FCM.CollectionID = ‘SMS00001′
This report gives you all percentage count with specific status for all advertisement in your environment. In order to get the list of machines where it is advertised with specific status,this report has to be linked to default report i.e 106.It works with SCCM , if you want to run the report in SMS 2003 ,see below after this code. SELECT AdvState.AdvertisementID, AdvName.AdvertisementName, AdvState.LastStateName, AdvState.number AS ‘Number of clients with this Status’, ROUND(100.0*AdvState.number/SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1 END),1) AS ‘Percent with this Status’, SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1 END) AS ‘Total # Clients with…
This report will list the computers where and When the RAM is changed ? select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0, Max(HRAM.TimeStamp) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_X86_PC_MEMORY RAM, dbo.v_HS_X86_PC_MEMORY HRAM Where CS.ResourceID = RAM.ResourceID and CS.ResourceID = HRAM.ResourceID and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0 Group by CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0
Below are some of the ports which are required to be open for proper communication. Port Requirements: -->SMS site server to Active Directory Service Name UDP TCP LDAP 389 389 LDAP SSL N/A 636 RPC Endpoint Mapper 135 135 Global Catalog LDAP N/A 3268 Global Catalog LDAP SSL N/A 3269 Kerberos 88 88 --> SMS 2003 Advanced Client to Active Directory In an Active Directory environment, the Advanced client makes a Lightweight Directory Access Protocol (LDAP) query to the global catalog server to find a management point that matches the client’s IP address. The following ports are required in Active…
the questions that are posted here needs some corrections,these are posted roughly. Technical Interview Questions – Active Directory What is Active Directory? Active directory is a centralized database which maintains information about the network objects, its access levels etc. What is LDAP? LDAP (Lightweight Directory Access Protocol) is a lightweight protocol which can be used for finding and accessing the directory objects and its properties. Can you connect Active Directory to other 3rd-party Directory Services? Name a few options. Yes, we can. Some of the third party directory services to which we can connect are LDAP, X500, NDS. Where is…
Had several systems which had wmi issue in doing client /application installation.This is most common issue which we face if something happens to the system.To get solved,use the script which can be run remotely using psexec tool. http://blogs.technet.com/b/configmgrteam/archive/2009/05/08/wmi-troubleshooting-tips.aspx Note : The below script tested only on Windows XP ,not tested on higher versions like Windows 7 Download the psexec tool from Microsoft .Here are the basic instruction in doing it. 1.copy the psexec.exe tool on to new folder (G:\script) and create 3 new files(wmifix.bat,computers.txt and run.bat).Each file script has given below. wmifix: @echo off REM WMI Repair Title WMI Repair…