Updated: 6/25/2004; 12:17:05 AM.
John Finnerty's Radio Weblog
        

Wednesday, March 03, 2004

  Message: 22
Date: Thu, 09 Oct 2003 18:39:41 -0000
From: "douglas_bentley"
Subject: Re: How to SUM Varchar fields

Barry,
Use cast or convert to change to similar type values, then sum.
convert((Open Time) as datetime)


Douglas Bentley
--- In magicsolutions@yahoogroups.com, "itbcm"
wrote:
> I need to create a calculated field on the "Incident" view, that
sums
> 3 other fields that are defined as Virtuals within the "Incident"
> view. These fields are defined as "varchar" in their respective
> views. So when I do a sum of these fields, I do not get a value.
> The values within these fields are always integer, if that helps.
>
> I am unsure of the format of the code I need to put in the
Validated
> field. I was wondering if anyone could help out with some
> suggestions.
>
> Barry Morshead



________________________________________________________________________
________________________________________________________________________

Message: 23
Date: Thu, 9 Oct 2003 14:47:23 -0400
From: "Ron Sorrell"
Subject: RE: How to SUM Varchar fields

Here is an example if you have decimals
(cast (base.HD_CCTXT01 as integer)) + (cast (base.HD_CCTXT02 as
integer))

or if you just have whole numbers, use this example
(cast (base.HD_CCTXT01 as smallint)) + (cast (base.HD_CCTXT02 as
smallint))

Note: I am using the column names
Ron Sorrell
Ron@nashco.ca
613-913-1540
Nashco Enterprises
A Network Associates Premier Partner
www.Nashco.ca
866-590-0846



-----Original Message-----
From: itbcm [mailto:barry.morshead@cdha.nshealth.ca]
Sent: October 9, 2003 2:20 PM
To: magicsolutions@yahoogroups.com
Subject: [magicsolutions] How to SUM Varchar fields


I need to create a calculated field on the "Incident" view, that sums
3 other fields that are defined as Virtuals within the "Incident"
view. These fields are defined as "varchar" in their respective
views. So when I do a sum of these fields, I do not get a value.
The values within these fields are always integer, if that helps.

I am unsure of the format of the code I need to put in the Validated
field. I was wondering if anyone could help out with some
suggestions.

Barry Morshead

 
October 6, 2003
  Software Fashion - Software Reality 
October 2, 2003
  257716 - INF: Frequently Asked Questions - SQL Server 2000 - Setup 

Powered by Blogger


7:36:21 AM    comment []

September 25, 2003
  Attachments Max. Size Modification

You can change it. Go into attachments.asp and search for MaxFileLength. It should read 153600 (1.5 * 1024000). You can change it to whatever you want. I also recommend changing the error message so that it reflects your new size limit. To find the error message, search for 10317." 
  As the whiteboard ID has to be unique, we make the whiteboard id the date backwards then brief info.

e.g. today would be 20030918-Internet

Having the date backwards makes it sort in order when trying to ind
old whiteboards.


We use whiteboards a lot for crisis management, but be aware if you are
using it to change the details in the problem description.
We used it for managing the blaster virus outbreak, saving time by
populating fields, and prompts such as Patched Y or N, Anti virus up to date Y or N etc. The trouble was on a few occasions someone update the whiteboard and all text was over written. With the default text.

Make sure you have an expiration, we try to guess when the problem will be resolved and extend this if needed. If you close a whiteboard without one it will sit scrolling across the screen forever. You have to open the
whiteboard, therefore all tickets and close them again.

Like Kathy's idea of restricting who can update whiteboards but in
reality
you may want whoever the call is assigned to to be able to close it
when
done, it depends how much control you need there, but it is a pain if
someone closes or changes the assign to in error.

My only other tip is to explain to people what they are, this saves
them
closing whiteboards with resolution see call #12345, or panicking that
there
are 50 calls in the queue, when they refer to the same issue.

-----Original Message-----
From: Magic User [mailto:magiccsm@yahoo.com]
Sent: Thursday, September 11, 2003 5:21 PM
To: magicsolutions@yahoogroups.com
Subject: Re: [magicsolutions] Help/Service Desks Whiteboards


Thanks for sharing! This is very helpful for the decision that needs to
be
made.
Kathy.

Justin Smith wrote:

Here are a few things we do with regard to Whiteboards:

- We've modified the ASP to make the scrolling whiteboard active by
default.
It's also set to refresh every 30 seconds or so, so that new
whiteboards
appear to staff not longer after their posted.

- Using data segregation, some groups' whiteboards are global, while
others
are local. For example, our call center is divided into first-level
(HELPDESK1) and second-level (HELPDESK2) groups. The first-level group
can
post whiteboards that are local so other units aren't annoyed by things
that
don't concern them. The second-level group can post global
whiteboards; we
use this to notify the entire company when a major problem strikes
(like the
mail server going down).

- Only a small number of staff members have rights to post/update
whiteboards. Because a single click can change (or close) all
Incidents
linked to a whiteboard, you have to be careful about who you give that
power
to.

- When I create email/pager notifications, I make sure to include a
line
that looks something like, "... AND {TR,WhiteboardID} Equals "
(where
is just a blank spot). We didn't want to spam the poor group
or
staff member who the whiteboard was assigned to by sending an
email/pager
notification every time someone linked a ticket to the whiteboard.

- When the whiteboard is Closed, a business rule kicks in and emails
all the
people who had tickets linked to the whiteboard. This lets them know
that
"the following major issue has been resolved".

- For clarity, I always put the date in the whiteboard note. This
ensures
people don't wonder if the whiteboard is stale and helps when sending
notifications based on the whiteboard closure.

- One of our units uses whiteboards to communicate jobs/projects
between the
daytime staff and nighttime staff. Obviously, their whiteboards are
segregated from everyone elses.
 
September 24, 2003
  Popchart service Parameters Registry Key.

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesPopChartServerParameters

Use the old MS-DOS name (e.g. C:Progra~1 instead of F:Program Files) to point at java.exe installed by the JRE 1.2.2 Runtinme from the Magic CD



 
September 22, 2003
  From Blueprint to Fortress: A Guide to Securing IIS 5.0 
  15 Seconds : Protecting Your IIS Server and Web Application 
  Secure Internet Information Services 5 Checklist 
  COM+ Administration: Understanding the Component Services Administrative Tool 
  229694 - HOW TO: Install and Use the IIS Security "What If" Tool: "HOW TO: Install and Use the IIS Security 'What If' Tool" 
  the WB Ticker automatically by adding the following line.

Search for the line that sais (line 25)

function StartWBTimer(){

on the line above type

StartWBTimer()

Save the document." 
September 20, 2003
  First Help Is Best - Computerworld 
  Subject: RE: Re: SIR problem - External Documents

Don
Find the file ProcessSearch.asp in your Magic Enterprise Directory
Find the following string: @contents
and replace with: $contents

This should work right away

This was corrected in an 7.5 hotfix but wasn't carried forward in SP1
or
MR1. This $Content will makes the query a free form text query against
the Microsoft Index Catalogs

Ron Sorrell
 
September 19, 2003
  VERIFYING DATABASE CONNECTIONS
(contributed by Brian Moran, savvy@sqlmag.com)

Q. I have a Visual Basic (VB) application that connects to a SQL
Server 2000 database. How can I verify that the client machine has a
TCP/IP sockets Net-Library connection to the database?

A. You can easily determine the Net-Library that a particular
connection is using by looking at the sysprocesses table's net_library
column in the master database. The master..sysprocesses table contains
one row for each connection to the server; a server process ID (SPID)
identifies each connection. The following query returns the
Net-Library that the connection is using:

SELECT net_library FROM master..
sysprocesses WHERE spid = @@spid

Running this T-SQL query from your application lets you determine
which Net-Library a connection from your application is using. Of
course, you can also manually inspect the sysprocesses table from
Query Analyzer to get the information you're looking for. TCP/IP will
be the value for the net_library column if you're connected through a
TCP/IP sockets connection. 
September 11, 2003
  SMTP and IIS 
  Eliminate the double-click to open Magic customization


Disclaimers: proceed at your own risk and peril! No support for this! Don't do it unless you know what you're doing and are willing to support this client after you've done it! Make a backup of any file you change!

The double-click actually works for both SA and GA. Find and comment this line (with "//") in options.asp:

document.ondblclick=OpenCustWiz_Ondblclick;

So you end up with:

//document.ondblclick=OpenCustWiz_Ondblclick;

This eliminates the double-click to open customization feature. This is oft-requested from ES, and should likely be issued by support as a patch (or moved into a flag setting). It causes the most grief for customers who wish to keep GA's out of customization.

7:35:26 AM    comment []

July 22, 2003
  The IIS SMTP Service 
  314546 - HOW TO: Move Databases Between Computers That Are Running SQL Server 
  307775 - INF: Disaster Recovery Articles for Microsoft SQL Server 
  268272 - CDO - MAPI Session Logon Fails with MAPI_E_LOGON_FAILED If No ThreadToken 
July 18, 2003
  Dealing with MS SQL Tables that contain Duplicate Rows: "

Free Newsletters:
DatabaseJournal
DBANews
Search Database Journal:
July 13, 2003
  ITIL Training and E-Learning Online 
  ITIL (IT Infrastructure Library) and ITSM Directory 
  British Computer Society 
  OGC - - ITIL 
  OGC - - Home 
  itSMF - Home 
  The ITIL Experts - Pink Elephant 
  Pink ElephantPink Elephant - Leading the Way in IT Service Management Best Practices 

7:34:46 AM    comment []

  280400 - How to Configure the SMTP Resource on a Windows 2000-Based Server Cluster 
  Manage Your Company's E-mail with the Windows 2000 SMTP Service  
  Annoyances.org - Print Out a Directory Listing 

7:34:05 AM    comment []

  MailTo Syntax 
December 16, 2003
  I had a customer that wanted to give out the rights to do admin on staff but not customization rights. By default if you give a user Sys Admin rights they can access customization via double clicking on the Nav Bar. To remove this feature you need to remove the following code from the options.asp file located in the Magic Enterprise directory:



{

if ((window.event.srcElement.tagName == "LABEL") || (window.event.srcElement.tagName == "IMG")) return

var adminusr = "[Macro error: Can't compile this script because of a syntax error.] "

// if login is SA or GA only then open the customization wizard

if ((adminusr == 2) || (adminusr == 3))

OpenWizard()

}

document.ondblclick=OpenCustWiz_Ondblclick;



Please backup the existing options.asp file and replace the modified one should you run into any issues.

Note that by changing Magic ASP code you are potentially putting you installation of Magic into an "unsupported" status with NAI support. Please make sure you understand this prior to implementing the change to the asp code and while working with support.


 
December 2, 2003
  Yahoo! News - Six decisions IT people shouldn't make 
  How can I back up the Microsoft IIS metabase in Windows 2000 and
later?

A. IIS configuration information resides in a metabase that consists
of an XML document. If you're hosting several Web sites that have
separate configurations, backing up the metabase is vital. To back up
the IIS metabase, perform the following steps:
1. Start the Microsoft Management Console (MMC) Internet
Information Services (IIS) snap-in (go to Start, Programs,
Administrative Tools, then click Internet Information Services
Manager).
2. Right-click the name of the machine that hosts the IIS services,
then select Backup/Restore Configuration from the All Tasks menu.
3. Click Create Backup.
4. Enter a name for the backup.
5. Optionally select the "Encrypt backup using password" check box
and enter a password to protect the backup.
6. Click OK.
7. Click Close on the main Backup/Restore Configuration window.

The OS will create a metabase backup in the
%windir%system32inetsrvmetaback folder. The backup consists of two
files: "name of backup".MDx and "name of backup".SCx. You should
ensure that you back up this folder as part of your routine system
backups. The .MDx file contains the actual metabase information, and
the .SCx file contains the schema. In both cases, "x" is the version
of the backup.

--------------------

Q. How can I restore the Microsoft IIS metabase backup in Windows 2000
and later?

A. You should be aware that you can't restore an IIS metabase backup
from another computer; however, Microsoft provides utilities for
copying IIS configuration information between machines. To restore an
IIS metabase backup, perform the following steps:
1. Start the Microsoft Management Console (MMC) Internet
Information Services (IIS) snap-in (go to Start, Programs,
Administrative Tools, then click Internet Information Services
Manager).
2. Right-click the name of the machine that hosts the IIS services,
then select Backup/Restore Configuration from the All Tasks menu.
3. Select the backup you want to restore, then click Restore.
4. When the system asks whether you're sure that you want to
continue, click Yes.
5. If the backup is password protected, you'll need to enter the
password.
6. After the backup restoration is finished, click OK to close the
confirmation window.

--------------------

Q. How can I back up the Microsoft IIS metabase from the command line
in Windows 2000 and later?

A. Win2K includes a Visual Basic (VB) script called metaback.vbs for
performing a command-line backup of the IIS metabase. The script
resides in the inetpubiissamplessdkadmin folder. To run the
script, open a command prompt and type

cscript metaback.vbs

where "backup name" is the name of the backup file you want to create.

Windows Server 2003 includes a VB script called iisback.vbs that
resides in the system32 folder for performing a command-line backup of
the IIS metabase. To run the script, open a command prompt and type

cscript iisback.vbs /backup /b

The /b switch specifies the backup name. Type

cscript /iisback.vbs /backup /?

to see other available options (e.g., automatic versioning) for the
iisback.vbs script.


Powered by Blogger


7:33:34 AM    comment []

  Personal Information Protection and Electronic Documents Act - An Unofficial Version of the Act - Privacy Commissioner of Canada 
February 13, 2004
  Data Access & Storage Home: Using SQL Server 2000 Technologies to Deliver Data (Microsoft SQL Server 2000 Technical Articles) 
February 11, 2004
  Web Page Design for Designers � Editorial February 2004#feature 
February 1, 2004
  Tips for Windows 2000 NT Administrators 
January 17, 2004
  LinuxDevCenter.com: Using and Customizing Knoppix [Nov. 20, 2003] 
January 11, 2004
  Index of /pub/Mandrake/iso 

7:32:26 AM    comment []

  WindowsDevCenter.com: Inside IIS 6 [Mar. 02, 2004] 
7:31:55 AM    comment []

© Copyright 2004 John Finnerty.
 
March 2004
Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      
Feb   Apr


Click here to visit the Radio UserLand website.

Subscribe to "John Finnerty's Radio Weblog" in Radio UserLand.

Click to see the XML version of this web page.

Click here to send an email to the editor of this weblog.