Description

Versions History

• Version 1.01:
  • You can now specify @NumberOfRecords@ as the column name in order to get the number of found records, instead of getting the actual records.
  • For example: the following command will display the number of opened Chrome windows:
    GUIPropView.exe /stab "" | GetNir @NumberOfRecords@ "Visible=Yes && ProcessFilename Like *chrome.exe"
• Version 1.00 - First release.

Examples for what you can do with GetNir

Be aware that the above examples will work only when the 'Add Header Line To CSV/Tab-Delimited File' option is turned on.

System Requirements

Usage

The [Display Columns] contains the name of one or more columns (comma-delimited list) to display. For example: "Install Location"   "Display Name,Display Version"
You can use the column numbers instead of column names, for example: "Column1,Column3"
If [Display Columns] is "@NumberOfRecords@", GetNir will display the number of found records.
If [Display Columns] is an empty string, GetNir will display the entire csv/tab-delimited line.

The [Filter Expression] is an expression similar to the SQL WHERE clause that filters the records you want to see.

In the {More Options} section you can use the following options:

The Filter Expression

• The filter expression is similar to the SQL WHERE clause and allows you to filter the records you want to see.
• You must put the entire filter expression in double quotes ("") and also every field name or string in the expression that contains one or more space characters must be in single quotes ('').
• When a column name has space characters, you can omit the spaces and then there is no need to put the name in single quotes. For example: Instead of 'Display Name', you can specify the column name as DisplayName.
• The following operators are supported: =   !=   >   <   >=   <=   Like Contains BeginsWith EndsWith Not And Or . You can use && instead of 'And' , || instead of 'Or', like in C/C++/C#/Java.
• The gt;   <   >=   <= operators can be used for numeric columns to get the desired range, for example: "Channel >= 1 && Channel <= 3"
• The Like operator checks a string using a wildcard, for example: "DisplayName LIKE 'Mozilla Firefox*'"   "SSID LIKE 'MyNet?'"
• The BeginsWith operator checks if a string begins with the specified string, for example: "DisplayName BeginsWith 'Mozilla Firefox'"
• The EndsWith operator checks if a string ends with the specified string, for example: "'Host Name' EndsWith .com"
• The Contains operator checks if a string contains the specified string, for example: "'Host Name' Contains Google"
• You can use the NOT operator to reverse the result, for example... If you want to get all records that their 'Host Name' doesn't contain the 'Google' string: "'Host Name' Not Contains Google"
• You can use column numbers instead of column names. Column1 for the first column, Column2 for the second column, and so on. For example: "Column1=5 && Column3=10"

Using GetNir With NirSoft Tools

This feature allows you work directly with GetNir without writing the data to a file.

In order to type the correct column name to display and filter, you have to look at the names of the columns as they appear in the GUI and inside exported files:

So now let's say that you want to get the uninstall string of Google Chrome from the UninstallView tool:
UninstallView.exe /stab "" | GetNir "Uninstall String" "'Registry Name'='Google Chrome'"

In the above command, UninstallView sends to stdout the list of all installed programs, as tab-delimited format. GetNir receives the data from UninstallView and searches the record with 'Google Chrome' value under the 'Registry Name' column. When GetNir finds the record, it display the value of 'Uninstall String' column:

You can also use the column names without space characters, for example:
UninstallView.exe /stab "" | GetNir "UninstallString" "RegistryName='Google Chrome'"

If you already have the csv/tab-delimited data on a file, you can also use GetNir to extract the desired value from the file, for example:
GetNir "UninstallString" "RegistryName='Google Chrome'" < uninstallview.csv

License

Disclaimer

Feedback