How To get Local Administrator Group Users On Sccm

Şirketlerde yaşadığımız en büyük problemlerden biri belkide local admin hakkı olan kullanıcılar. Bu ayarlar sayesinde artık mof file düzenleyerek envanterlerinizde  clientlarınızdan local administrator grubundaki kullanıcıların raporunu sccm aracılığı ile toplayabileceksiniz.   ______________ 1-Sccm > Administration > Client Settings > Default Client Settings 2. Export to  Hardware Inventory >Set Classes> Export .Mof file 3.Edit the .mof file write bottom:   [ SMS_Report (TRUE),   SMS_Group_Name (“LocalAdmins”),   SMS_Class_ID (“MICROSOFT|LocalAdmins|1.0”),   Namespace (“root\\\\cimv2”) ] class Win32_LocalAdmins : SMS_Class_Template {     [SMS_Report (TRUE), key ] string Account;     [SMS_Report (TRUE)      ] string Domain;    …

Devamını OKU

Sccm Application Filter for Device Collection

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “Microsoft Office%” and SMS_G_System_ADD_REMOVE_PROGRAMS.Version like “%” order by SMS_R_System.Name

Devamını OKU

Sccm Detaylı Bilgisayar Envanter Raporu

Rapor aşağıdaki özellikleri içerir. Computer name – Ad Site- Username, OS – Service Pack  –  Marka -Model – Seri No – Bios Date – Bios Version – Kurulum Tarihi – Memory – Memory Slots –  Type(x64,86) – Pc Type – SELECT DISTINCT sys.Name0 ‘Machine’, sys.AD_Site_Name0 ‘ADSite’, CS.UserName0 ‘User Name’, CASE WHEN U.TopConsoleUser0 = ‘-1’ OR U.TopConsoleUser0 IS NULL THEN ‘N/A’ ELSE U.TopConsoleUser0 END as TopUser, REPLACE (OS.Caption0, ‘Microsoft Windows’,’Win’) OS, REPLACE (OS.CSDVersion0,’Service Pack’,’SP’) ‘Service Pack’, CS.Manufacturer0 ‘Manufacturer’, CS.Model0 Model, BIOS.SerialNumber0 ‘Serial Number’, BIOS.ReleaseDate0 as BIOSDate, BIOS.SMBIOSBIOSVersion0 as BIOSVersion, (SELECT CONVERT(DATE,sys.Creation_Date0))…

Devamını OKU

Sccm Application Filter Report Query

select distinct P.DisplayName0 as ProductName, P.InstallDate0 as InstallDate, S.Netbios_Name0 as ComputerName, S.User_Name0 as LastUser, S.Operating_System_Name_and0 as OperatingSystem, S.Last_Logon_Timestamp0 as LastSeen from [dbo].[v_Add_Remove_Programs] as P, [dbo].[v_R_System] as S where S.ResourceID = P.ResourceID and (P.DisplayName0 like ‘Microsoft Visual Studio %Premium%’ or P.DisplayName0 like ‘Microsoft Visual Studio %Ultimate%’ or P.DisplayName0 like ‘Microsoft Visual Studio %Professional%’ or P.DisplayName0 like ‘Microsoft Visual Studio %Express%’ ) and P.InstallDate0 is not null order by S.Netbios_Name0

Devamını OKU

Uygulama Kullanım Raporu Çekme SCCM – Software Metering Use

SELECT MU.Domain, MU.UserName, SF.FileName, SF.FileVersion, MUS.UsageCount, MUS.UsageTime, MUS.LastUsage FROM v_MeteredUser MU INNER JOIN v_MonthlyUsageSummary MUS ON MU.MeteredUserID = MUS.MeteredUserID INNER JOIN v_GS_SoftwareFile SF ON MUS.FileID = SF.FileID ORDER BY MU.Domain, MU.UserName, SF.FileName if you need just excel.exe you should write IM Renderer Page <table class=”msgText”> <tr> <td class=”errorAlertIco”><img src=”res://instant-message.dll/#10/#2415″ /></td> <td class=”boxedMessageText”>It appears that you do not have JavaScript enabled, please contact your adminitrator.</td> </tr> </table> SELECT MU.Domain, MU.UserName, SF.FileName, SF.FileVersion, MUS.UsageCount, MUS.UsageTime, MUS.LastUsage FROM v_MeteredUser MU INNER JOIN v_MonthlyUsageSummary MUS ON MU.MeteredUserID = MUS.MeteredUserID INNER JOIN v_GS_SoftwareFile SF ON…

Devamını OKU

Computer Inventory with Monitor Reports with SQL on SCCM

We should write; select v_R_System.Name0, v_GS_PC_BIOS.Manufacturer0, v_GS_PC_BIOS.SerialNumber0,v_GS_COMPUTER_SYSTEM.Model0, AD_Site_Name0, User_Name0 FROM v_R_System JOIN v_GS_PC_BIOS on v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID JOIN v_GS_COMPUTER_SYSTEM on v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID if you need Computer model you should write; SELECT Manufacturer00, model00, name00 FROM Computer_System_DATA İf you need Monitor inventory Sql Querry you can write select v_GS_COMPUTER_SYSTEM.[Name0] AS ‘Computer Name’, v_GS_COMPUTER_SYSTEM.[UserName0] AS ‘User Name’, v_GS_COMPUTER_SYSTEM.[UserName0] AS ‘User Name’, v_GS_COMPUTER_SYSTEM.[Manufacturer0] AS ‘Manufacturer’, v_GS_COMPUTER_SYSTEM.[Model0] AS ‘Model’, /* v_GS_NETWORK_ADAPTER.[Name0] AS ‘Network Adapter name’, v_GS_NETWORK_ADAPTER.[AdapterType0] AS ‘Network Adapter Type’, v_GS_NETWORK_ADAPTER.[Description0] AS ‘Network Adapter Description’, v_GS_NETWORK_ADAPTER.[Manufacturer0] AS ‘Network Adapter Manufacturer’, */ v_GS_SYSTEM_ENCLOSURE.[SerialNumber0] AS…

Devamını OKU