SpiraTeam query all users and roles

I needed a script for an audit of SpiraTeam to query all users and roles. And here it is: /****** Script for SelectTopRows command from SpiraTeam ******/ SELECT TOP 1000000 [FULL_NAME] ,[PROJECT_ROLE_NAME] ,[PROJECT_NAME] ,[ACTIVE_YN] FROM [SpiraTeam].[dbo].[VW_PROJECT_USER] where ACTIVE_YN like ‘Y’…

mssql truncate all log files

Learn in MSSQL how to truncate all log files! This transact-sql statement uses the core truncation method recommended by Microsoft.mssql truncate all log files mssql truncate all log files on a MSSQL 2000, 2005 server DECLARE @db varchar(255) declare @sql…

alternative svn backup method

alternative svn backup method. Sometimes svnsync, hotcopy, etc just won’t work for you. Here’s the solution! 1. Create a user with same name and password on each of your servers, example: host1_live_svn_server – backup_usr host2_backup_server – backup_usr 2. Setup SSH…

freebsd set bash default shell

freebsd set bash default shell First you need to figure out where bash was installed: $ which bash /usr/local/bin/bash Now use chsh as show below $chsh -s /usr/local/bin/bash Password: chsh: user information updated