PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
600 reads
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
600 reads
Script to collect and export the mailbox properties from Get-Mailbox and Get-MailboxStatistics cmdlets to a CSV file
This script can be extended based...
2016-01-07
667 reads
During the upgrade to XenApp 7.6 FP3 VDA encountered the following message.
I was wondered on seeing this popup to restart...
2016-01-06
551 reads
We can install MongoDB as a windows service. The steps are given below
Prerequisite –
Install Hotfix kb2731284 on the MongoDB Server...
2016-01-05
1,814 reads
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2016-01-04
330 reads
Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate...
2015-12-26
749 reads
SELECT DISTINCT s.Netbios_Name0 AS ComputerName,
s.Operating_System_Name_and0 AS OSName,
pr.Name0 AS ProcessorTypeSpeed,
pr.Manufacturer0 Manufacturer,
pr.NumberOfCores0 Cores,
pr.NumberOfLogicalProcessors0 LgicalProcessorCount,
case when pr.DataWidth0=64 then '64 bit'else'32 bit' end DataWidth,
m.TotalPhysicalMemory0/1024.00 AS MemoryMB,
GS1.TotalVirtualMemorySize0 VirtualMemory,
GS1.TotalVisibleMemorySize0 VisibleMemory,
ip.IPAddress0,
T1.COL AS TotalDriveSize,
LastBootUpTime0,
DATEDIFF(Day,GS1.LastBootUpTime0, GETDATE()) AS [Days since last boot]
FROM v_R_System_Valid s
INNER JOIN v_GS_PROCESSOR pr ON s.ResourceID = pr.ResourceID
INNER JOIN v_GS_COMPUTER_SYSTEM gs ON s.ResourceID = gs.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER ON s.ResourceID = v_GS_NETWORK_ADAPTER.ResourceID
INNER JOIN v_GS_X86_PC_MEMORY m ON s.ResourceID = m.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGURATION ip ON s.ResourceID = ip.ResourceID
-- INNER JOIN v_GS_LOGICAL_DISK AS ld ON s.ResourceID = ld.ResourceID
INNER JOIN
( SELECT RESOURCENAME,
col
FROM
(
SELECT DISTINCT TAB.Netbios_Name0 RESOURCENAME,
(
SELECT COL.deviceid0 +' '+ cast(COL.Size0/1024.00 AS varchar(20))+' '
FROM v_GS_LOGICAL_DISK COL
WHERE
COL.ResourceID = TAB.ResourceID AND COL.DriveType0=3
FOR XML PATH ('')
) COL
FROM v_R_System_Valid TAB
)T
where T.COL is NOT NULL
) T1 on T1.RESOURCENAME=s.Netbios_Name0
INNER JOIN V_GS_OPERATING_SYSTEM GS1 on GS1.ResourceID=s.ResourceID
WHERE
s.Operating_System_Name_and0 LIKE '%Windows NT Server%'
AND
ip.IPAddress0 IS NOT NULL AND ip.DefaultIPGateway0 IS NOT NULL
2015-12-11
641 reads
The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot...
2015-08-26
967 reads
declare @table table
(
[Paid Date] date
)
insert into @table
values('20150102'),('20150512'),('20150830'),('20151231'),('20141230')
;WITH Quarters AS (
SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION
SELECT Q = 'Q2',...
2015-03-19 (first published: 2015-03-11)
7,778 reads
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
920 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I am using the following sql to convert rows into columns for each pid,...
Comments posted to this topic are about the item Ingesting Data From REST API...
Comments posted to this topic are about the item Separate Reads
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers