Tips and Tricks

#PSTip Functions and SQL filtering, Part 3

Bartek Bielawski
3 Min To Read
30 Jul, 2014
- Tips and tricks
- SQL

Note: This tip requires PowerShell 3.0 or later. Whenever we retrieve information from SQL database we are faced with the problem: are we happy with column names defined in database schema?

#PSTip Functions and SQL filtering, Part 2

Bartek Bielawski
2 Min To Read
29 Jul, 2014
- Tips and tricks
- SQL

Note: This tip requires PowerShell 3.0 or later. Adding support for easy filtering on individual table columns is great, but the fact that user would have to use SQL wildcard syntax rather than wildcards that he is used to, makes it feel like a …

#PSTip Functions and SQL filtering, Part 1

Bartek Bielawski
3 Min To Read
28 Jul, 2014
- SQL
- Tips and tricks

Note: This tip requires PowerShell 2.0 or later. This is the first tip in a series of SQL filtering tips.

#PSTip Show friendly GPO names with Get-ADOrganizationalUnit

Jaap Brasser
1 Min To Read
25 Jul, 2014
- Tips and tricks

When using the Get-ADOrganizationalUnit cmdlet there is a property available, LinkedGroupPolicyObjects. Unfortunately, that property only displays the GUID of the Group Policy Objects.

#PSTip Select non-administrative shared folders using Win32_Share WMI class

Jaap Brasser
1 Min To Read
24 Jul, 2014
- Tips and tricks
- Wmi

Note: This tip required PowerShell 3.0 or above The Win32_Share WMI class can be used to enumerate all shares on the local or remote system.

#PSTip Enumerating mapped network drives using WScript.Network

Jaap Brasser
1 Min To Read
23 Jul, 2014
- Tips and tricks

In the ‘Create mapped network drive using WScript.Network‘ tip, it was shown how a mapped drive can be mounted. The WScript.

Showing items from Tips and Tricks