{"id":850,"date":"2008-12-01T23:00:28","date_gmt":"2008-12-02T07:00:28","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2008\/12\/01\/december-powershell-one-liner\/"},"modified":"2008-12-01T23:00:28","modified_gmt":"2008-12-02T07:00:28","slug":"december-powershell-one-liner","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2008\/12\/01\/december-powershell-one-liner\/","title":{"rendered":"December PowerShell One-Liner"},"content":{"rendered":"

This month’s PowerShell one-liner uses WMI to query event logs on remote computers. Specifically it is searching for logs that record when the Event Log service has started. This is another way you can, determine when a computer has started. It’s not foolproof of course but the one-liner should serve as an example of querying WMI on multiple machines.<\/p>\n

\n
\n
   1:<\/span> Get-WmiObject win32_ntlogevent -filter<\/span> `<\/pre>\n
   2:<\/span> \"logfile='system' AND EventCode=6005 AND TimeWritten > `<\/pre>\n
   3:<\/span> '$((get-date).AddDays(-30).toShortDateString())'\"<\/span> `<\/pre>\n
   4:<\/span> -computername (get-content computers.txt) | <\/pre>\n
   5:<\/span> Select @{name=\"Computername\"<\/span>;Expression={$_.__Server}},`<\/pre>\n
   6:<\/span> @{name=\"StartUp\"<\/span>;Expression={$_.ConvertToDateTime($_.timewritten)}}<\/pre>\n<\/div>\n<\/div>\n
This expression queries a list of computers and finds the specific event records written in the last 30 days.<\/p>\n
\n
Download a text file with this expression here.<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
This month’s PowerShell one-liner uses WMI to query event logs on remote computers. Specifically it is searching for logs that record when the Event Log service has started. This is another way you can, determine when a computer has started. It’s not foolproof of course but the one-liner should serve as an example of querying WMI on multiple machines.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[403,249,28,191,35],"class_list":["post-850","post","type-post","status-publish","format-standard","hentry","category-windows-powershell","tag-eventlog","tag-get-wmiobject","tag-powershell","tag-sapien","tag-wmi"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=850"}],"version-history":[{"count":1,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/850\/revisions"}],"predecessor-version":[{"id":851,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/850\/revisions\/851"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}