As the "go to" guy for SEP on campus an interesting question came up, "How can I get a list of my machines that are actually running on SEP?" The SEP Manager (SEPM) has quite a few options, but the reports section seemed to be missing an option to export a list of all your machines. After searching around, I did find a solution. The trick is to go to the log section, not the reports section.

So in SEPM go to "Monitors" and choose the "Logs" tab. Then choose the log type of "Computer Status." Hit the button to get advanced settings. Then in the "Domain" field you'll want to enter your SEPM domain name so you only get your machines, otherwise you'll get all of them from all SEPM domains (unless that's what you want). You'll also want to expand the time range when searching. The default of last 24 hours will only show machines that have checked-in in the last 24 hours, so you'll want to expand that appropriately to your search. You can also add additional criteria if you like to limit the results. Once you create the filter you like, feel free to save it as something so you can select it easily in the future. Then click "View Log." Once there you can look at them or hit the "Export" link at the top. When you choose export it automatically creates a comma separated text file that Excel can open easily. The save dialog box names it by default with the extension of .txt, so to make Excel open it easily its easiest to just save it with the .csv extension instead. The export is basically a full dump of everything it knows about that machine currently.