codepaq

Tuesday, October 12, 2021

Get Disk Space Info Remotely

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

Assign local admin rights remotely

To view the local admin users of the PC you are currently using:


net localgroup administrators

After downloading and saving PSTools to a folder, which include psexec.exe, and making it available globally through System Variables -> Path, you can run the "net locagroup" command on remote PCs, given that you already have local admin rights to those PCs.

To view the local admin users of another PC remotely, try


psexec  \\<ip_address>  net  localgroup administrators

To add a user to the local admin group remotely:


psexec \\<ip_address>  net localgroup administratos "<domain_name>\<username>" /add

To remove a user from the local admin group remotely:


psexec \\<ip_address>  net localgroup administratos "<domain_name>\<username>" /delete

Thursday, June 4, 2020

Visual Studio 2013 - Run as administrator - The application cannot start.

All of a sudden, Visual Studio 2013 no longer works with the error message "The application cannot start" when trying to run it as local administrator.

For those of us who prefer to host a development environment using local IIS server (not IIS Express), this could be a show stopper.

Running the "devenv.exe /resetuserdata" did not help. Uninstall/Re-install of VS 2013 did not help either.

Try the following and see if it helps.

Open the folder "C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\
Look for files that start with "dte" and "*.olb" extension. For example,

dte80.olb
dte80a.olb
dte90.olb
dte90a.olb
dte100.olb

Copy all of these files.
Paste them into "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE

Monday, January 20, 2020

Simple sticky bottom footer

Simple sticky bottom footer example with text-overflow hidden with ellipses.

<!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>

Monday, April 8, 2019

Number Only Field - Quick Input Mask

Quick way to allow decimal or integer numbers only in a form.

$(".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	print
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	e-mail
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

Monday, October 22, 2018

C: drive gets full on IIS server

I came across two scenarios where the C: drive gets completely full on a IIS server. I suspected the log file folder first, but it turned out to be something else hidden.

Scenario 1: I ran a warmup script that uses an instance of IE to fully mimics a full page load of web applications, not just page hit.
Scenario 2: I set up an IIS server as a dedicated SharePoint provider-hosted on-prem web server. Over time, the C: drive was getting full. Warmup script used to run for a while on this server.

In both cases, the following folder was the culprit. When using an instance of IE, it probably used this folder for caching.

C:\Windows\SysWOW64\config\systemprofile\AppData\Local\Microsoft\Windows\INetCache\

Thursday, August 30, 2018

SSRS: Remove Duplicates in Parameter Drop-down

While SharePoint was being queries from a SSRS report, GroupBy did not work in the CAML query in the DataSet definition of the SSRS report.

One workaround was to use a global VB function inside the report, which removes duplicate parameter values in a parameter dropdown.

https://social.technet.microsoft.com/wiki/contents/articles/36632.ssrs-remove-duplicate-filter-values-from-parameter-drop-down-using-vb-code.aspx