Häufige WMI-Abfragen


Hier ein paar typische WMI-Abfragen, z.B. anzuwenden in der WMI-Filterung für Gruppenrichtlinien oder bei der Konfiguration von BGInfo. Kommentare und Erläuterungen in [eckigen Klammern] hinter den jeweiligen Abfragen.

Akku-Status (Notebook)
SELECT * FROM Win32_Battery WHERE EstimatedChargeRemaining > ’20‘  [Restladekapazität >20%]
SELECT EstimatedChargeRemaining FROM Win32_Battery

Datum
SELECT Day AND Month AND Year FROM Win32_CurrentTime
SELECT DayOfWeek FROM Win32_CurrentTime

Bildschirm
SELECT ScreenWidth FROM Win32_DesktopMonitor
SELECT ScreenHeight FROM Win32_DesktopMonitor
SELECT SystemName FROM Win32_DesktopMonitor WHERE ScreenWidth = 1024 AND ScreenHeight = 768  [alle Systeme mit einer Auflösung von 1024×768]
SELECT * FROM Win32_DesktopMonitor WHERE ScreenHeight = 768
SELECT * FROM Win32_DesktopMonitor WHERE ScreenWidth = 1024
SELECT SystemName FROM Win32_DesktopMonitor WHERE DeviceID = ‚DesktopMonitor1‘ AND ScreenWidth > 800 AND ScreenHeight > 600  [ggf. DesktopMonitor2 bei weiteren Bildschirmen]

Routingtabelle
SELECT NextHop FROM Win32_IP4RouteTable  [Abfrage des Gateways]
SELECT Metric1 FROM Win32_IP4RouteTable WHERE NextHop = ‚192.168.1.1‘  [Abfrage der hinterlegten Metrik zum Gateway]
SELECT Destination FROM Win32_IP4PersistedRouteTable  [Fest eingetragene Netzwerke]

Laufwerke
SELECT FileSystem FROM Win32_LogicalDisk

Arbeitsspeicher
SELECT EndingAddress FROM Win32_MemoryDevice  [Verfügbarer RAM in KB]
SELECT Capacity FROM Win32_PhysicalMemory  [Verfügbarer RAM in B]
SELECT MaxCapacity FROM Win32_PhysicalMemoryArray  [Maximal steckbarer RAM in KB]

Netzwerkkarten
SELECT IPAddress FROM Win32_NetworkAdapterConfiguration WHERE IPenabled = TRUE
SELECT DefaultIPGateway FROM Win32_NetworkAdapterConfiguration WHERE IPenabled = TRUE
SELECT IPAddress FROM Win32_NetworkAdapterConfiguration WHERE IPenabled = TRUE AND DHCPEnabled = TRUE
SELECT DNSServerSearchOrder FROM Win32_NetworkAdapterConfiguration WHERE IPenabled = TRUE

NT Profil
SELECT FullName FROM Win32_NetworkLoginProfile WHERE UserType = ‚Normal Account‘
oder
SELECT * FROM Win32_NetworkLoginProfile WHERE FullName IS NOT NULL

Domäne / Domain Controller
SELECT * FROM Win32_NTDomain WHERE DomainControllerAddressType IS NOT NULL
SELECT ClientSiteName FROM Win32_NTDomain WHERE ClientSiteName IS NOT NULL
SELECT DcSiteName FROM Win32_NTDomain WHERE DcSiteName IS NOT NULL
SELECT DnsForestname FROM Win32_NTDomain WHERE DnsForestName IS NOT NULL  [Domain Suffix]
SELECT DomainControllerAddress FROM Win32_NTDomain WHERE DomainControllerAddress IS NOT NULL
SELECT DomainControllerName FROM Win32_NTDomain WHERE DomainControllerName IS NOT NULL
SELECT DomainName FROM Win32_NTDomain WHERE DomainName IS NOT NULL  [Domänen-NetBIOS Name]

Betriebssystem
SELECT Caption FROM Win32_OperatingSystem  [OS Anzeigename]
SELECT * FROM Win32_OperatingSystem WHERE Version > ‚6.0‘  [Alle Windowssysteme mit einer OS-Version > 6.0]
SELECT BuildNumber FROM Win32_OperatingSystem
SELECT * FROM Win32_OperatingSystem WHERE OSArchitecture = ’64-Bit‘ [Alle 64bit Systeme]

Festplatte
SELECT SerialNumber FROM Win32_PhysicalMedia  [Seriennummer der Festplatten]

Drucker
SELECT * FROM Win32_Printer WHERE DriverName = ‚Druckerfreigabename‘

Prozessor
SELECT AddressWidth FROM Win32_Processor  [= 32 or 64 bit]
SELECT Name FROM Win32_Processor

Dienste
SELECT * FROM Win32_Service WHERE State = ‚Running‘  [Alle Dienste im Status ‚Gestartet‘]
SELECT * FROM Win32_Service WHERE Name = ‚Dnscache‘  [DNS-Client Dienst]


7 Antworten zu “Häufige WMI-Abfragen”

  1. I have frequently considered precisely how vital it actually is
    to uncover our individual limits, and in addition our individual biggest strenghts.
    While you’re working on the things that you may be good at, you really feel a whole lot more in touch with yourself.

    Whenever you are participating in some thing which is definitely complicated, many times
    you prefer it since it is an effort. I’ve truly noted that there are some folks who are in the position to discover their own aptitudes, though
    there’re some others whose life circumstances made that unfeasible.

    A lot of people also don’t understand that kids massage therapy has helped youngsters whose relatives happen to be going through
    adversity. Alleviating worry or nervousness in young boys and girls brings about minimised pressure for the mom and dad,
    who can then inhabit their unique day-to-day lives in a very stress-free manner, sometimes taking far better
    care of their selves as well.

    Exactly what I actually concern myself most in regard to is wellbeing
    information. I signed up for journals dealing with this subject, and I continue to keep informed about the latest health studies.
    In what way is this relevant? Personally, I think
    there is no more critical emphasis for my hours. Likewise, this blog website entry
    seems as if it’s deserving the time to read. I dig through literally thousands or even more of websites weekly.
    Truth be told, my back usually is uncomfortable and I
    desire a new spare time interest. lol In any case, I believe if everybody published about their
    place in life, and did it articulately, we’d have a much more robust globe. https://danceordieforever.Wordpress.com/tag/kids-massage/

  2. Now i am all the time endeavoring to keep current on the most
    recently released medical resources regarding gestation, taking into
    consideration that my personal gig in life is just as a massage during pregnancy therapist.

    During dealing with this unique population, I just see that
    there is certainly very little which in turn any pair of
    persons share outside of the truth that they’ve been expectant.
    Of course, massage during pregnancy, prenatal yoga and fitness, and also getting a labor
    and birth doula are typically ideas most likely to be pretty widely pertinent to get the
    absolute best birth and labor experience. https://pregnancy-massage-nj.njmassage.info/Images/Pregnant-Mom-And-Toddler-500px.jpg

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert