Posts Tagged ‘csv’


 

PrimalScript adds Custom PrimalSense (Part 3: Cached and dynamic data lists)

Thursday, September 17th, 2015 by Alex Riedel
With the latest service build (7.1.67) of PrimalScript 2015 we introduced a new feature; custom PrimalSense. In the first part of this series we showed you how to create a simple list and what options you have for providing data for these lists. In the second part we showed you how to make these lists multi-select and how to add images to your items. If you missed the previous posts, click here for part 1 and here for part 2. Some if the information you want to display in a PrimalSense list is not static. It can change dynamically from…   More »

PrimalScript adds Custom PrimalSense (Part 2: Images and multiple selection)

Wednesday, September 16th, 2015 by Alex Riedel
With the latest service build (7.1.67) of PrimalScript 2015 we introduced a new feature; custom PrimalSense. In the first part of this series we showed you how to create a simple list and what options you have for providing data for these lists. If you missed the post, click here. If your list has just a single type of items an image is not really necessary, but if you have different types, it would be nice to give these items a visual distinction. Let’s take a look at the ‘machines’ example that gets installed with PrimalScript. We have different icons…   More »

PrimalScript adds Custom PrimalSense (Part 1: Basic lists and static data)

Tuesday, September 15th, 2015 by Alex Riedel
With the latest service build (7.1.67) of PrimalScript 2015 we introduced a new feature; custom PrimalSense. While many items in a script can be determined dynamically based on context and offered as a selection in a list, there are equally as many items that are tied to your specific environment or your business logic. There is simply no way we can foresee these items and offer them as you need them. What we can do however, is to enable you to customize PrimalSense and create your own lists, based on your needs and your environment. Invoking these custom lists is…   More »

WMI Explorer 2014: Running Queries

Tuesday, September 3rd, 2013 by Alex Riedel
WMI has a large amount of namespaces, classes and properties. While the WMI Explorer allows you to browse, search and filter all these items, it also enables you to query the underlying data for all of this. What you see above here is a standard query for the selected class. It is the same as running a “select * from Win32_Service” in this case. You can also limit the number of columns or properties by only selecting the items you need. In this case we selected the ‘Caption’ and ‘State’ properties only to get a list of all services and…   More »

How would you change PrimalCSV?

Thursday, August 15th, 2013 by Alex Riedel
PrimalCSV is another one of our community tools up for a review. As CSV is one of the file formats frequently used by administrators to transport large amounts of data from one script to the other, the need for a specialized tool is pretty clear. Whether you just need to see a file to verify its correct structure or need to actually edit the file to adapt the output of a one-off PowerShell command to the input for a script, PrimalCSV has the basics. Because it's a single exe file, it is pretty easy to use without installation. On a…   More »

Export-CSV, now what?

Friday, May 7th, 2010 by Alex Riedel
PowerShell 2.0 has added the ability to export and import objects and store them as CSV files. CSV (Comma Separated Values) files have been a common file format since they where first used around 1967 on IBM mainframes and have been in constant use since then. If you need to edit CSV files most people use Microsoft Excel, which registers as the default editor for the .CSV extension. This is fine on your desktop or laptop computer, but when was the last time you found a Windows 2008 R2 server with Microsoft Office installed? At that point, your friendly neighborhood…   More »

Out-CSV Revised

Friday, May 15th, 2009 by Jeffery Hicks
A while ago I published a short function to create CSV strings. While working on another task I came across $OFS, which is something I know about but never really think about. $OFS is an intrinsic PowerShell variable that controls the output field separator for arrays. You can modify this variable which made me realize there was a better way to handle my Out-CSV function. Here's the revised function.   More »

Out-CSV

Thursday, April 2nd, 2009 by Jeffery Hicks
Sometimes it's the little things that can make life easier. Here's one of them. We know that PowerShell treats comma separated items as an array: PS C:\> $a="a",1,"b","jeff",4 PS C:\> $a a 1 b jeff 4 PS C:\> But what if you want back in its original comma delimited list? Or suppose you wanted to create a comma delimited line of all running services? Export-CSV isn't really going to help in these situations. I came up with function called Out-CSV.   More »

Management Reporting in Windows PowerShell

Monday, February 25th, 2008 by Don Jones
Ever wonder how you can use PowerShell's native abilities to produce great-looking management reports - in CSV files, Eccel spreadsheets, HTML pages, and even charts and graphs? Well, come on down to TechMentor San Francisco where I'll be giving a session on exactly that topic - along with a bunch more on Windows PowerShell, security, Windows fundamentals, tips and tricks, and more. When you register, use promotion code TPJON and you'll save almost $700 off a Gold Passport full-access pass, which lets you attend any session you want and gets you some nifty benefits besides. Plus I'll buy ya a beverage…   More »

Read Remote Registry Function

Thursday, February 14th, 2008 by Jeffery Hicks
Hopefully you found my last entry valuable. But I always like to take things a step further, especially when it comes to scripting and automation. So I turned my last script into a function that returns the value of a specified registry key   More »