Georgia Telnet or SSH generate a list of users for GS_L_User.txt

Published June 30, 2018 / by Chris Smith / Leave a Comment

Georgia Telnet can restrict the number of users that connect to Telnet or SSH. I am lazy so I tend to generate a list based off our user logon scripts folders, however I do of course take a backup and test it afterwards.

echo Change to the drive where your Georgia logon scripts are located
d:
echo Change to the folder to where your Georgia logon scripts are located
cd D:\Datalinx\GS_UTS\scripts
echo Get the dir command to write out a simple list of directories into a file called dir.txt
dir /B /A:D >dir.txt
echo add a 1 to end of each row and copy the list into the file GS_L_User.txt located normally a directory above the user script folders.
echo It takes place straight away

echo Change to the drive where your Georgia logon scripts are located

echo Change to the folder to where your Georgia logon scripts are located

cd D:\Datalinx\GS_UTS\scripts

echo Get the dir command to write out a simple list of directories into a file called dir.txt

dir /B /A:D >dir.txt

echo add a 1 to end of each row and copy the list into the file GS_L_User.txt located normally a directory above the user script folders.

echo It takes place straight away

Additional information: Georgia Telnet Manual and Logon Features

Creating a shortcut to a non existent location on Windows

Published May 13, 2018 / by Chris Smith / Leave a Comment

Credit: ServerFault Credit: Craig Tolley I came across the need to create a shortcut to a non existent file share (Where a wireless network had a different ip range on a different site). I thought Windows would let shortcuts for SMB shares be created if they didn’t exist, but Windows 10 insisted the share had […]

Disable Word Press from allowing saving of the username and password from the login screen

Published April 30, 2018 / by Chris Smith / Leave a Comment

A plugin which isn’t in the Word Press list of available plugins is one I find very handy from Benjamin Uzelac. It disables Word Press from allowing the browser to save the username and password and that’s it. Its good for complying with the usual website tests, which flag saving a username and password as […]

Use T-Sql to find triggers on specific database

Published March 25, 2018 / by Chris Smith / Leave a Comment

Credit: Joe Stefanelli on Stack Overflow I wanted a simple way to find triggers on a specific database, Joe Stefanelli posted SQL which did exactly what I wanted.

SELECT 
     sysobjects.name AS trigger_name 
    ,USER_NAME(sysobjects.uid) AS trigger_owner 
    ,s.name AS table_schema 
    ,OBJECT_NAME(parent_obj) AS table_name 
    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate 
    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete 
    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert 
    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter 
    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof 
    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled] 
FROM sysobjects
INNER JOIN sysusers 
    ON sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t 
    ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s 
    ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'

SELECT

sysobjects.name AS trigger_name

,USER_NAME(sysobjects.uid) AS trigger_owner

,s.name AS table_schema

,OBJECT_NAME(parent_obj) AS table_name

,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate

,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete

,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert

,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter

,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof

,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]

FROM sysobjects

INNER JOIN sysusers

ON sysobjects.uid = sysusers.uid

INNER JOIN sys.tables t

ON sysobjects.parent_obj = t.object_id

INNER JOIN sys.schemas s

ON t.schema_id = s.schema_id

WHERE sysobjects.type = 'TR'

Display the old USB Device Removal Tab

Published February 11, 2018 / by Chris Smith / Leave a Comment

Credit: Waseemulla S on Microsoft Answers I had a USB device that I could not unload, I prefer the old dialog box anyway and found it is still possible to show this box in Windows 10. The forum post above has the answer, however according to someone was a very poor answer. For me the […]

Batch script to help with launching files for correct version of Windows

Published January 20, 2018 / by Chris Smith / Leave a Comment

We encountered an issue during a migration to Windows 10 where I had missed a program which had hard coded links, these no longer worked due to Microsoft Access being a newer version. I generated a simple script so we could change the hard coded links to allow it to select the correct version, all […]

Generate a text file with subfolders in a location on explorer

Published January 20, 2018 / by Chris Smith / Leave a Comment

I needed to generate a list of folders and their subfolders, I used a simple command for dir command and slapped into a text file. Below replaced with the folder you want to get the list from (i.e C:\Users\Default) and replace with where you want to save a textfile (i.e C:\textfile.txt).

dir /b /s /a:d "<Location>\*" > <TextFile>

1	dir /b /s /a:d "<Location>\*" > <TextFile>

Credit: SS64

Find unused MSSQL indexs on a database

Published December 23, 2017 / by Chris Smith / Leave a Comment

Credit: Basit’s SQL Server Tips The following is very handy to check for any unused index’s on a MSSQL database, this should only be run once the database has been up for at least a week or when all scheculed jobs have been allowed to run at least once. The only change I made is […]

SQL Server 2008 – Find which stored procedure is part of a scheduled

Published November 25, 2017 / by Chris Smith / Leave a Comment

Find a stored procedure (or any text) inside a scheduled on on SQL Server 2008 and 2012 by querying the sysjobs and sysjobsteps system tables. The following provides the name of the job and the step name. It uses the standard % wildcard so replace myjob in “%myjob%” below

SELECT name, "description", "enabled", database_name,step_name,step_id,command
       FROM "msdb"."dbo"."sysjobsteps" t1
              INNER JOIN "msdb"."dbo"."sysjobs" t2 on t1.job_id = t2.job_id
       where t1."command" LIKE '%myjob%'

SELECT name, "description", "enabled", database_name,step_name,step_id,command

FROM "msdb"."dbo"."sysjobsteps" t1

INNER JOIN "msdb"."dbo"."sysjobs" t2 on t1.job_id = t2.job_id

where t1."command" LIKE '%myjob%'

More info on SQL system […]

Getting a Kodak i160 to work on a KEC 1582t card in Windows 7

Published November 12, 2017 / by Chris Smith / Leave a Comment

We had an issue where a Kodak i160 scanner would appear when a Windows 7 machine booted but then disappear after the Kodak i160 scanner went to sleep. The Kodak scanner was using a Kofax Virtual Rescan driver, after some checking it turned out the machine was using a standard fire wire driver for the […]

CJSmith dot me

I dump stuff I find useful here