One of the quick and easy ways to get a remote computer/server's disk space info is to use the PowerShell command GET-PSDrive.
You can create a batch file that runs the GET-PSDrive command remotely using PSTools' PSExec.
@echo off
psexec \\{ip_address} cmd /c powershell.exe "Get-PSDrive"
pause
net localgroup administrators
psexec \\<ip_address> net localgroup administrators
psexec \\<ip_address> net localgroup administratos "<domain_name>\<username>" /add
psexec \\<ip_address> net localgroup administratos "<domain_name>\<username>" /delete
<!doctype>
<html><head><title>Sticky Bottom Footer</title>
<style>
#content {
text-align: center;
}
#google_promo {
position: fixed;
bottom: 30px;
left: 0;
right: 0;
text-align: center;
transition: bottom 400ms;
}
.promo-content {
border: 1px solid #ccc;
border-radius: 16px;
display: inline-block;
padding: 0 16px;
width: 237px;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
</style>
</head>
<body>
<div id="content">
<h1>Simple Sticky Bottom Footer</h1>
<div id="google_promo">
<div class="promo-content">
Hello, I am a sticky footer. It's simple to create me.
</div>
</div>
</div>
</body>
</html>
$(".allowDecimal").on("keypress keyup blur", function (event) {
$(this).val($(this).val().replace(/[^0-9\.]/g,''));
if ((event.which != 46 || $(this).val().indexOf('.') != -1)
&& (event.which < 48 || event.which > 57))
{
event.preventDefault();
}
});
$(".allowIntegerOnly").on("keypress keyup blur", function (event) {
$(this).val($(this).val().replace(/[^\d].+/, ""));
if ((event.which < 48 || event.which > 57))
{
event.preventDefault();
}
});
| Key Code | Key |
|---|---|
| 0 | That key has no keycode |
| 3 | break |
| 8 | backspace / delete |
| 9 | tab |
| 12 | clear |
| 13 | enter |
| 16 | shift |
| 17 | ctrl |
| 18 | alt |
| 19 | pause/break |
| 20 | caps lock |
| 21 | hangul |
| 25 | hanja |
| 27 | escape |
| 28 | conversion |
| 29 | non-conversion |
| 32 | spacebar |
| 33 | page up |
| 34 | page down |
| 35 | end |
| 36 | home |
| 37 | left arrow |
| 38 | up arrow |
| 39 | right arrow |
| 40 | down arrow |
| 41 | select |
| 42 | |
| 43 | execute |
| 44 | Print Screen |
| 45 | insert |
| 46 | delete |
| 47 | help |
| 48 | 0 |
| 49 | 1 |
| 50 | 2 |
| 51 | 3 |
| 52 | 4 |
| 53 | 5 |
| 54 | 6 |
| 55 | 7 |
| 56 | 8 |
| 57 | 9 |
| 58 | : |
| 59 | semicolon (firefox), equals |
| 60 | < |
| 61 | equals (firefox) |
| 63 | ß |
| 64 | @ (firefox) |
| 65 | a |
| 66 | b |
| 67 | c |
| 68 | d |
| 69 | e |
| 70 | f |
| 71 | g |
| 72 | h |
| 73 | i |
| 74 | j |
| 75 | k |
| 76 | l |
| 77 | m |
| 78 | n |
| 79 | o |
| 80 | p |
| 81 | q |
| 82 | r |
| 83 | s |
| 84 | t |
| 85 | u |
| 86 | v |
| 87 | w |
| 88 | x |
| 89 | y |
| 90 | z |
| 91 | Windows Key / Left ⌘ / Chromebook Search key |
| 92 | right window key |
| 93 | Windows Menu / Right ⌘ |
| 95 | sleep |
| 96 | numpad 0 |
| 97 | numpad 1 |
| 98 | numpad 2 |
| 99 | numpad 3 |
| 100 | numpad 4 |
| 101 | numpad 5 |
| 102 | numpad 6 |
| 103 | numpad 7 |
| 104 | numpad 8 |
| 105 | numpad 9 |
| 106 | multiply |
| 107 | add |
| 108 | numpad period (firefox) |
| 109 | subtract |
| 110 | decimal point |
| 111 | divide |
| 112 | f1 |
| 113 | f2 |
| 114 | f3 |
| 115 | f4 |
| 116 | f5 |
| 117 | f6 |
| 118 | f7 |
| 119 | f8 |
| 120 | f9 |
| 121 | f10 |
| 122 | f11 |
| 123 | f12 |
| 124 | f13 |
| 125 | f14 |
| 126 | f15 |
| 127 | f16 |
| 128 | f17 |
| 129 | f18 |
| 130 | f19 |
| 131 | f20 |
| 132 | f21 |
| 133 | f22 |
| 134 | f23 |
| 135 | f24 |
| 144 | num lock |
| 145 | scroll lock |
| 160 | ^ |
| 161 | ! |
| 162 | ؛ (arabic semicolon) |
| 163 | # |
| 164 | $ |
| 165 | ù |
| 166 | page backward |
| 167 | page forward |
| 168 | refresh |
| 169 | closing paren (AZERTY) |
| 170 | * |
| 171 | ~ + * key |
| 172 | home key |
| 173 | minus (firefox), mute/unmute |
| 174 | decrease volume level |
| 175 | increase volume level |
| 176 | next |
| 177 | previous |
| 178 | stop |
| 179 | play/pause |
| 180 | |
| 181 | mute/unmute (firefox) |
| 182 | decrease volume level (firefox) |
| 183 | increase volume level (firefox) |
| 186 | semi-colon / ñ |
| 187 | equal sign |
| 188 | comma |
| 189 | dash |
| 190 | period |
| 191 | forward slash / ç |
| 192 | grave accent / ñ / æ / ö |
| 193 | ?, / or ° |
| 194 | numpad period (chrome) |
| 219 | open bracket |
| 220 | back slash |
| 221 | close bracket / å |
| 222 | single quote / ø / ä |
| 223 | ` |
| 224 | left or right ⌘ key (firefox) |
| 225 | altgr |
| 226 | < /git >, left back slash |
| 230 | GNOME Compose Key |
| 231 | ç |
| 233 | XF86Forward |
| 234 | XF86Back |
| 235 | non-conversion |
| 240 | alphanumeric |
| 242 | hiragana/katakana |
| 243 | half-width/full-width |
| 244 | kanji |
| 251 | unlock trackpad (Chrome/Edge) |
| 255 | toggle touchpad |
INSERT INTO table1 exec sp_GetProducts @CategoryID=12Stored procedures that returns tabular results in SQL Server do not allow saving the results in a new table like we would expect (The receiving table must exist with all columns' data types and fields names ahead of time for the query to work).
sp_configure 'Show Advanced Options', 1 GO RECONFIGURE GO sp_configure 'Ad Hoc Distributed Queries', 1 GO RECONFIGURE GO SELECT * INTO table1 FROM OPENROWSET ( 'sqlncli', 'server=(local)\SQL12;trusted_connection=yes', 'exec Northwind.dbo.sp_GetProducts @CategoryID=12' );
CREATE FUNCTION GetProductsByCategory
(
@CategoryID int
)
RETURNS TABLE
AS
RETURN
select * from dbo.Products where CategoryID=@CategoryID
GO
SELECT *
INTO table1
FROM GetProductsByCategory(12);
GO
# Get SMTP server info
$smtp=new-object Net.Mail.SmtpClient("myEmailServer.myDomain.com")
# Set thresholds in GB for C: drive and other drives
$driveCthreshold=10
$threshold=10
# Replace settings below with your e-mails
$emailFrom="serverToMinitor@myDomain.com"
$emailTo="myName@myDomain.com"
# -----------------------------------------------------------------------------
# Get server name
$hostname=Get-WMIObject Win32_ComputerSystem | Select-Object -ExpandProperty name
# Get all drives with free space less than a threshold, while excluding System Volumes
$Results = Get-WmiObject -Class Win32_Volume -Filter "SystemVolume='False' AND DriveType=3" | Where-Object {($_.FreeSpace/1GB –lt $driveCthreshold –and $_.DriveLetter -eq "C:") –or ($_.FreeSpace/1GB –lt $threshold –and $_.DriveLetter -ne "C:" )}
If ( ($Results | measure).Count -gt 0 )
{
ForEach ($Result In $Results)
{
$drive = $Result.DriveLetter
$space = $Result.FreeSpace
$thresh = if($drive -eq 'C:'){$driveCthreshold} else {$threshold}
# Send e-mail if the free space is less than threshold parameter
$smtp.Send(
$emailFrom,
$emailTo,
# E-mail subject
"Disk $drive on $hostname has less than $thresh GB of free space left ",
# E-mail body
("{0:N0}" -f [math]::truncate($space/1MB))+" MB"
)
}
}
[HttpGet]
pulic FileContentResult GetFile(int id)
{
var binary = db.Binaries.Find(id);
if (binary == null)
{
return null;
}
byte[] binaryData = binary.BinaryData;
string mimeType = binary.MimeType;
string fileName = binary.FileName;
return File(binaryData, mimeType, fileName);
}
[HttpGet]
public ActionResult OpenFile(int id)
{
var binary = db.Binaries.Find(id);
if (binary == null)
{
return null;
}
var contentDisposition = new System.Net.Mime.ContentDisposition
{
FileName = binary.FileName, Inline = false
};
Response.AddHeader("Content-Disposition", "inline; filename=" + binary.FileName);
return File(binary.BinaryData, binary.MimeType);
}
<configuration>
...
<system.web>
<httpRuntime targetFramework="4.5" executionTimeout="3600" maxRequestLength="1048576" />
</system.web>
...
<system.webServer>
<security>
<requestFiltering>
<requestLimits maxAllowedContentLength="1073741824" /> <!-- 1 GB in bytes -->
</requestFiltering>
</security>
</system.webServer>
...
</configuration>
/*-- Get all databases' mdf and ldf info, including logical names --*/ SELECT * FROM SYS.MASTER_FILES /*-- Get mdf info (more detail) -- */ SELECT * FROM SYS.DATABASES /*-- Get mdf info (less detail) --*/ SELECT * FROM SYS.SYSDATABASES /*-- Get database info -- */ EXEC sp_helpdb /*-- Get database info (mdf and ldf), including logical names --*/ EXEC sp_helpdb @dbname = N'Northwind'
DECLARE @DB_NAME varchar(1000)
SELECT @DB_NAME = 'Northwind_DB'
DECLARE @AllConnections TABLE(
SPID INT,
Status VARCHAR(MAX),
LOGIN VARCHAR(MAX),
HostName VARCHAR(MAX),
BlkBy VARCHAR(MAX),
DBName VARCHAR(MAX),
Command VARCHAR(MAX),
CPUTime INT,
DiskIO INT,
LastBatch VARCHAR(MAX),
ProgramName VARCHAR(MAX),
SPID_1 INT,
REQUESTID INT
)
INSERT INTO @AllConnections EXEC sp_who2
SELECT * FROM @AllConnections WHERE DBName = @DB_Name
ORDER BY HostName
/* Update statistics in [msdb] database */ USE msdb; GO UPDATE STATISTICS backupfile; GO UPDATE STATISTICS backupmediafamily; GO UPDATE STATISTICS backupmediaset; GO UPDATE STATISTICS backupset; GO UPDATE STATISTICS restorefile; GO UPDATE STATISTICS restorefilegroup; GO UPDATE STATISTICS restorehistory; GO /* Create an index on [backupset] table in [msdb] database for [database_name] column */ Create index IX_backupset_database_name on backupset(database_name); GO
<!--SPM:<SharePoint:CssRegistration runat="server" ID="CssRegistration1" Name="<% $SPUrl:~sitecollection/Style Library/style.css %>" After="corev15.css"/>-->
<!--SPM:<SharePoint:ScriptLink runat="server" ID="ScriptLink1" Language="javascript" Name="~sitecollection/Style Library/script.js"/>-->