Category: Andet
Test SMTP TLS with OpenSSL with Auth
On a linux box type these two commands The command will return with the username and password in base64 format.Example: So now you need to telnet with OpenSSL to the mailserver: After you have...
Match Veeam replicas folder with VM
If you need to see what VM, that match to a VEEAM Replica folder on the disk system, this can be the solutionThe veeam replica folder looks like this: Let say that you need...
SQL Agent Job history – T SQL
Here are a Script, that you can use to extract the SQL Agent Job History This will also tell you the job steps Thanks to Chad Churchwell – https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/
Update Service with new SSL certificate
Some service SSL certificate is adminstrate though netsh start netsh, though a CMD, with just type: netsh If you then type: http show sslcert, you can see SSL certificate information: So to update this...
Lenovo Update ONECLI
OneCli.exe update acquire –scope latest –mt 7X06 –os win2016 –dir C:\Lenovo\Driver Onecli.exe update flash –dir C:\Lenovo\Driver –scope latest You find ONECLI on Lenovo Support page, under the specific server Please change -mt to the...
Change autodiscover URL (EWS URL / OAB URL / ECP URL / Activesync URL) – Exchange 2016 / Exchange 2019
If you want to change Mapi, Autodiscover / EWS / OAB / OWA / ECP / Activesync Url, this is how it works Example you have bought a certificate on you external name, and...
mssql get the backup information with copy_only information.
I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on a forum.https://dba.stackexchange.com/questions/204883/how-to-tell-if-a-backup-log-chain-is-broken The script...
See if a database is using Enterprise features of an Microsoft SQL server.
Run this command to see if any database on the SQL Server is using enterprise features
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL DROP TABLE ##enterprise_features CREATE TABLE ##enterprise_features ( dbname SYSNAME, feature_name VARCHAR(100), feature_id INT ) EXEC sp_msforeachdb N' USE [?] IF (SELECT COUNT(*) FROM sys.dm_db_persisted_sku_features) >0 BEGIN INSERT INTO ##enterprise_features SELECT dbname=DB_NAME(),feature_name,feature_id FROM sys.dm_db_persisted_sku_features END ' SELECT * FROM ##enterprise_features |
Sidste kommentar