Archives: January 2014
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter the computer name that you would like to get the memory details for and click on Get Memory Button.
This pulls out the usage of memory of the listed computer.… Read more
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing both 32-bit and 64-bit applications. This code also contains an exclusion array where you can exclude list of program that you don’t want to show.
- The function allows -ComputerName parameter…
The below query help us in finding the physical existence of data and log files are on same drive or not of all the database in a SQL Instance.
;WITH LogCTE AS ( SELECT DISTINCT LD.Database_Name FROM ( SELECT DB_NAME(database_id) AS [Database_Name], LEFT(Physical_Name, 1) AS [Drive_Letter] FROM sys.master_files WHERE type_desc…
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from one of SQL enthusiast. The requirement is to do with T-SQL to monitor disk space of remote servers.
- Enable XP_CMDShell
- Enable Ole automation on all servers
Step by… Read more
Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a SQL Server Agent job, but the job names are Unique Identifier its hard to remember and re-call. Have complete information in single query makes one easy to validate and execute… Read more
Useful links – I hope you might like it too..
Here’s a very quick post by request.I just had a request for searching the file system for files matching certain criteria such as file age based on the date created. The function Get-FileAgingReport uses get-childitem cmdlet. This function uses two mandatory input parameters Computername and Folder Path.The function is validated… Read more
Method 1: Environment Variable
Method 2: Using Win32_OperatingSystem
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the size of this instance. The value of this property is 4 in a 32-bit process, and 8 in a… Read more