Skip to main content

SQL Server DB inventory

with the following query db inventory of a sql server can be retrieved:

SELECT
SERVERPROPERTY('ServerName') as 'Server Name',
@@VERSION as 'SQL Version',
SERVERPROPERTY('productversion') as 'SQL Server Versiyon Number',
CASE SERVERPROPERTY('IsIntegratedSecurityOnly') WHEN 0 THEN 'Mix' ELSE 'Windows' END as 'Auth Mode',
dbs.name as 'Database Name',
dbs.collation_name as 'Collation',
mf.physical_name as 'Database File'
FROM sys.master_files as mf, sys.databases as dbs
WHERE (mf.database_id dbs.database_id) and (dbs.name not in ('master', 'model', 'msdb', 'tempdb'));

Comments

Popular posts from this blog

Sending Jboss Server Logs to Logstash Using Filebeat with Multiline Support

In addition to sending system logs to logstash, it is possible to add a prospector section to the filebeat.yml for jboss server logs. Sometimes jboss server.log has single events made up from several lines of messages. In such cases Filebeat should be configured for a multiline prospector.
Filebeat takes lines do not start with a date pattern (look at pattern in the multiline section "^[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}" and negate section is set to true) and combines them with the previous line that starts with a date pattern.

server.log file excerpt where DatePattern: yyyy-MM-dd-HH and ConversionPattern: %d %-5p [%c] %m%n
Logstash filter: