{"id":1734,"date":"2010-08-25T22:33:21","date_gmt":"2010-08-25T20:33:21","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1734"},"modified":"2010-08-25T22:33:21","modified_gmt":"2010-08-25T20:33:21","slug":"export-agents-to-excel","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=1734","title":{"rendered":"Export agents to Excel"},"content":{"rendered":"<p>A common questions in the forums is &#8220;<em>how to export a list of all agents to Excel?<\/em>&#8221; You can do that with Operations Manager shell. The Operations Manager command shell is built on Windows PowerShell. The Operations Manager command shell extends the Windows command shell with over 80 additional small utility programs, called <em>cmdlets<\/em>, which can either be run directly from the command shell prompt or called from within a batch file or script. To export a list of all agents and some info about them run the following command<\/p>\n<blockquote><p>get-agent | select Displayname,InstallTime,InstalledBy,Version | export-csv -notype c:\\agents.csv<\/p><\/blockquote>\n<p>That will give you a CSV file, C:\\agents.csv. Open the file with Excel, select all the data,\u00c2\u00a0click the &#8220;text to columns&#8221; button and choose comma delimeter. That will convert your data into nice columns.<\/p>\n<p><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2010\/08\/toexcel01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1735\" title=\"toexcel01\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2010\/08\/toexcel01-300x147.jpg\" alt=\"\" width=\"300\" height=\"147\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2010\/08\/toexcel01-300x147.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2010\/08\/toexcel01.jpg 688w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&#8230;and there you have your list in Excel with nice columns<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A common questions in the forums is &#8220;how to export a list of all agents to Excel?&#8221; You can do that with Operations Manager shell. The Operations Manager command shell is built on Windows PowerShell. The Operations Manager command shell extends the Windows command shell with over 80 additional small utility programs, called cmdlets, which &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=1734\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"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":[19],"tags":[],"class_list":["post-1734","post","type-post","status-publish","format-standard","hentry","category-operations-manager-2007"],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1734"}],"version-history":[{"count":2,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1734\/revisions"}],"predecessor-version":[{"id":1737,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1734\/revisions\/1737"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1734"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}