Graph Ping Time with Microsoft LogParser

This content is 7 years old. Technology changes with time. Keep that in mind as you read this article.

Found this cool little piece while searching for log parsers for a project.

ping -n 15 www.yahoo.com | logparser SELECT TO_INT(REPLACE_STR(EXTRACT_VALUE(Text,'time',' '),'ms','')) AS Response INTO Ping.gif FROM stdin WHERE Text LIKE '%%Reply%%' GROUP BY Response -i textline -legend off -chartTitle Ping Times -view

This is from Ken Shaefer’s blog from 2005!

Windows XP SP3 installed, or is it?

This content is 7 years old. Technology changes with time. Keep that in mind as you read this article.

Here’s today’s riddle:

width=300

I'm

I got this interesting problem after installing SP3 on a Windows XP Home system via the Network Install Service Pack 3 download.

Action Plan

  1. Uninstall SP3 from Add/Remove Programs
  2. Install SP3 via Windows Update

Error number: 0x80070424

This content is 7 years old. Technology changes with time. Keep that in mind as you read this article.

Windows Update error 0x80070424

Quick fix:

%SYSTEMROOT%SYSTEM32REGSVR32.EXE %SYSTEMROOT%SYSTEM32WUAUENG.DLL

Microsoft SQL Database-level Roles

This content is 7 years old. Technology changes with time. Keep that in mind as you read this article.

Database-level role names

from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx

db_accessadmin

Members of the db_accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.

db_backupoperator

Members of the db_backupoperator fixed database role can back up the database.

db_datareader

Members of the db_datareader fixed database role can read all data from all user tables.

db_datawriter

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.

db_ddladmin

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

db_denydatareader

Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database.

db_denydatawriter

Members of the db_denydatawriter fixed database role cannot add, modify, or delete any data in the user tables within a database.

db_owner

Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database.

db_securityadmin

Members of the db_securityadmin fixed database role can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation.

 

In theory, a user who can do nearly everything but modify access and security permissions:

Misys Vision Slow to Load Fast Services Screen

This content is 7 years old. Technology changes with time. Keep that in mind as you read this article.

I’ve seen that it takes >1hr to load the FastServices window after clicking on the FastServices button.

Here’s what I did to make this take less than 10 seconds to load.  It appears as though it does some type of parsing/processing of old log and inbox files.

# cd /Medic/APPS/fastsvc
# ls -l
total 264
drwxr-xr-x 4 dev medgrp 512 Dec 5 15:33 inbox
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:31 logs
drwxrwxrwx 2 dev medgrp 512 Dec 5 15:14 outbox
drwxrwxrwx 2 dev medgrp 512 Dec 5 15:23 tmp

I moved log to logs.org and inbox to inbox.org.

# mv logs logs.org
# mv inbox inbox.org

After that, I created .fast_images directory in the inbox folder and also created .data directory in inbox.

# ls -l inbox
total 16
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:33 .data
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:33 .fast_images

Then, I chown’d the proper permissions.

# chown dev.medgrp inbox
# chown dev.medgrp inbox/.data
# chown dev.medgrp inbox/.fast_images
# chown dev.medgrp logs