22 mai 2015 5 22 /05 /mai /2015 07:56

Requête pour lister les portables, laptop, notebook... (par taille d’écran)

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_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("8","9","10","14","12","11","17","23","15","7","6","10")

Requête pour lister un logiciel installé sur les postes (Irfanview)

select SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_G_System_SYSTEM.Domain, SMS_R_System.IPAddresses, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserName from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "IrFanView" order by SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_G_System_SYSTEM.Domain

Requête pour Savoir ou est logger un utilisateur

SELECT Name, LastLogonUserName, SMSAssignedSites, Client, IPAddresses, IPSubnets, MACAddresses, OperatingSystemNameandVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, AgentName, AgentSite, AgentTime, SNMPCommunityName, SystemRoles, SMSUniqueIdentifier, ResourceId, ResourceNames, ResourceType, NetbiosName from sms_r_system where LastLogonUserName = ##PRM:sms_r_system.LastLogonUserName##

Requête pour trouver un fichier sur les postes

select distinct SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileDescription, SMS_G_System_SoftwareFile.FileName, SMS_R_System.LastLogonUserName, SMS_R_System.IPAddresses, SMS_R_System.ResourceDomainORWorkgroup from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileDescription = "MarkitWire Client" and SMS_G_System_SoftwareFile.FileName = "viruslol.exe" order by SMS_R_System.NetbiosName

Requête pour lister la RAM

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserDomain, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory from SMS_R_System inner join SMS_G_System_PHYSICAL_MEMORY on SMS_G_System_PHYSICAL_MEMORY.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceId = SMS_R_System.ResourceId where SMS_G_System_PHYSICAL_MEMORY.Capacity <= 4096 order by SMS_R_System.NetbiosName

Requête pour lister le type de disque dur

select SMS_R_System.NetbiosName, SMS_R_System.ADSiteName, SMS_G_System_DISK.Caption from SMS_R_System inner join SMS_G_System_DISK on SMS_G_System_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DISK.DeviceID = "\\\\.\\PHYSICALDRIVE0"

Partager cet article

Repost 0
Publié par Vaks - dans TUTOS info
commenter cet article

commentaires