Skip to content

Instantly share code, notes, and snippets.

@matejskubic
matejskubic / EthernetAsMetered.bat
Created June 13, 2016 17:38
How to set an Ethernet Connection as Metered to control Updates, Drivers, Store and others
REM source: https://answers.microsoft.com/en-us/windows/forum/windows_10-networking/how-to-set-an-ethernet-connection-as-metered-to/ecdaca08-d413-4a6a-9e33-b4afb337fc18?auth=1
REM The key is [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\DefaultMediaCost]
REM There are entries under it for 3G, 4G, Default, Ethernet and Wifi. The normal settings for 3G and 4G are 2. For Ethernet and Wifi (and Default) it is 1. 2 means metered, 1 means not metered. So to make Ethernet Metered, the value needs to be changed from 1 to 2.
rem run from install directory
cd /d C:\Program Files\Windows Resource Kits\Tools\
rem change owner to Administrators
rem should report: Done: 1, Modified 1, Failed 0, Syntax errors 0
subinacl /subkeyreg "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\DefaultMediaCost" /setowner=administrators
@matejskubic
matejskubic / mssql-connections-details.sql
Created December 23, 2015 10:04
SQL Server connections details
select b.spid, b.hostname, b.program_name, a.net_transport, a.auth_scheme
from sys.dm_exec_connections a
inner join sys.sysprocesses b
on a.session_id = b.spid
@matejskubic
matejskubic / join-temporal-interval.sql
Created December 18, 2015 14:33
Join temporal intervals with valid from and to intersections
declare @x table(xf date, xt date, name varchar(50))
declare @y table(yf date, yt date, name varchar(50))
declare @z table(zf date, zt date, name varchar(50))
insert @x values ('2000-01-01', '2000-01-05', 'X1')
insert @x values ('2000-01-06', '2000-01-20', 'X2')
insert @y values ('2000-01-01', '2000-01-10', 'Y1')
insert @y values ('2000-01-11', '2000-01-20', 'Y2')
insert @z values ('2000-01-01', '2000-01-15', 'Z1')
insert @z values ('2000-01-16', '2000-01-20', 'Z2')
@matejskubic
matejskubic / PostBuild.ps1
Created September 25, 2015 01:01
Publish Build output to azure
[CmdletBinding(DefaultParameterSetName="UseContextVariables")]
Param(
# folder to upload
[parameter(Position=0, ParameterSetName="UseArgs", Mandatory=$true)]
[string]$dropLocation = (Get-Variable $dropLocation -ValueOnly -ErrorAction SilentlyContinue)
,
# upload location - sugned Azure blob url with upload permission
[uri]$blobFileUri="http://$_StorageAccount.blob.core.windows.net/$_Company/Appl.zip?sr=b&sv=2015-02-21&si=deploy$Company&sig=$_Signature"
,
# build version - added to Metadata.AxModelVersion
@matejskubic
matejskubic / ShowAdUserGroups.bat
Created September 8, 2015 11:14
Window for AD user search and its properties
Rundll32 dsquery.dll OpenQueryWindow
@matejskubic
matejskubic / Get-UserGroups.ps1
Created June 10, 2015 11:12
Saves user group membership to csv
Import-Module ActiveDirectory
Get-ADPrincipalGroupMembership (Read-Host "Username")|select SamAccountName| sort SamAccountName | ConvertTo-Csv -NoTypeInformation > "$($env:TEMP)\user-groups.csv"
start "$($env:TEMP)\user-groups.csv"
@matejskubic
matejskubic / runasNetOnly.bat
Created April 4, 2015 20:50
RunAs for network access only
runas /user:domain\user /netonly %1
@matejskubic
matejskubic / CreateEml.ps1
Created April 1, 2015 20:45
Create eml file from powershell
$mailMessage = New-Object System.Net.Mail.MailMessage
$mailMessage.From = New-Object System.Net.Mail.MailAddress("name@from.dom")
$mailMessage.To.Add("name@to.dom")
$mailMessage.Subject = "FYI: How to save mail messages to .eml files"
$mailMessage.Body = "This can be accomplished by changing the smtp delivery method to a pickup directory..."
$smtpClient = New-Object System.Net.Mail.SmtpClient
$smtpClient.DeliveryMethod = [System.Net.Mail.SmtpDeliveryMethod]::SpecifiedPickupDirectory;
@matejskubic
matejskubic / IterationBoard
Created April 1, 2015 19:51
Add background color to requirements on the backlog taskboard
<!-- \Program Files\Microsoft Team Foundation Server 12.0\Application Tier\Web Services\_areas\Agile\Views\Backlogs\IterationBoard.aspx -->
<!-- add at the end of <asp:Content ContentPlaceHolderID="RightHubContent" runat="server"> -->
<script defer="defer" type="application/javascript">
function popraviOzadje()
{
try
{
var taskboardData = JSON.parse(document.getElementById('taskboard').children[0].innerHTML);
var parentIds = taskboardData.parentIds;
var stateCol = 0;
@matejskubic
matejskubic / gist:8a20bfb2c052f01c7b13
Created March 11, 2015 13:44
AX 2012 - DeleteFiscalCalendarYear
static void DeleteFiscalCalendarYear(Args _args)
{
FiscalCalendarYear fiscalCalendarYear;
FiscalCalendarPeriod fiscalCalendarPeriod;
LedgerFiscalCalendarPeriod ledgerFiscalCalendarPeriod;
LedgerPeriodModuleAccessControl ledgerPeriodModuleAccessControl;
FiscalYearName yearToDelete = '2011';
ttsBegin;