posts-powershell

Categories

Tags

Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShell

Getting Installed Updates

PowerShell is great for parsing log files. Here is a function that extracts all installed Windows updates from an internal log file and returns the...

E-mail-Address-Extractor via RegEx

Regular expressions are extremely powerful - and complex. Fortunately, there are plenty of sources for good regular expressions that describe all...

Accessing WMI Instances in One Line

While you can use Get-WMIObject to query for WMI objects and then select the ones you are really after, you can also cast a WMI object path to a WMI...

Grouping with Script Blocks

Group-Object creates groups based on object properties. For example, you could group processes by company or folder listings by extension: Dir...

Replace Text in Files

Often, some text will need to be replaced in a text file. That's easy with Get-Content and Set-Content - or not? Get-Content c:somefile.txt |...

Sorting Multiple Properties

Sort-Object can sort on multiple properties at the same time. Have a look: Get-Service | Sort-Object Status, Name This will list stopped services...

Discover Hidden Object Members

Get-Member is a great cmdlet to discover object members, but it will not show everything: "Hello" | Get-Member You should add -force to...

Adding Extra Information

Sometimes you may want to tag results returned by a cmdlet with some extra information, such as a reference to some PC name or a timestamp. You can...

Making Objects Read/Write

Whenever you pipe objects through Select-Object, you actually get a copy of the original object. All properties are now readable and writeable, so...

Creating Relative Dates

To create relative dates like "10 days ago," there are two paths. Administrators often add or remove time spans created by New-Timespan:...

Create Remoting Solutions

Whenever you use WMI (Get-WMIObject) to retrieve information, it's a snap to turn a local solution into a remotable solution. You can just add...

How Much RAM Do You Have?

Ever wondered what type of RAM your PC uses and if there is a bank available to add more? Ask WMI! This example also converts the cryptic type codes...

Accessing Object Properties

Objects store information in various properties. There are two approaches if you would like to get to the content of a given property. One is...

Changing File/Folder Creation Date

You should use this approach if you need to change the creation time of a folder or file after you have created it: Get-Childitem c:\testfolder |...

Changing Error Background Color

If you would like to make error messages more readable, you can change their background color from black to white:...

Removing Empty Things

How do you exclude objects based on empty properties? For example, WMI returns all kinds of "network adapters:" Get-WMIObject...

Filtering Day of Week

You can also use this little helper function if you run scripts every day and want to make sure they don't do anything on weekends: function...

Finding Object Types

When you pipe the result of a command to Get-Member, it examines the returned objects and shows the properties and methods. Use this line if you...

Built-in Methods

Strings contain all the methods you may need to access its content or manipulate it otherwise. Here is how you can list those methods: "Hello" |...

Stopping Programs Gracefully

While Stop-Process will stop a process immediately in PowerShell, it will also destroy all data that hasn't yet been saved. You can try a more...

Create HTML System Reports

ConvertTo-HTML is a great way of creating system reports because you can combine information gathered from different sources into one report. The...

Create HTML reports

ConvertTo-HTML will convert text information into simple HTML, which can then be saved to disk. These reports will work fine, even though they are...

Printing Results

You will discover that Out-Printer can print results to your default printer. You can also print to any other printer when you specify its name:...

Outputting Text Data to File

When you output results to text files, you will find that the same width restrictions apply that are active when you output into the console. You...

Examining Object Data

If you need to see all properties a result object provides, you should probably add Select-Object * to it like this: Get-Process -Id $pid |...

Multi-Column Lists

If you need to display a lot of information in as little room as possible, you should use Format-List with -Column: Get-Service | Format-Wide...

Create Groups (and Examine Alias groups)

Format-Table has a parameter called -GroupBy which creates groups based on the property you supply. For example, you can use this to examine aliases...

Getting IPv4 Addresses

You should use WMI to list all IPv4 addresses assigned to a computer: Get-WMIObject win32_NetworkAdapterConfiguration | Where-Object { $_.IPEnabled...

Automating Native Commands

You'll discover that some native commands require interactive keystrokes before they work. For example, to format a drive, for security reasons you...

Finding Update History

Whenever Windows installs an update via Windows Update, it will log this in its windowsupdate.log file. PowerShell can then parse this file. You...

1 80 81 82 83 84 95