Updated: 6/3/2003; 9:38:06 AM.
John Finnerty's Radio Weblog
        

Thursday, May 15, 2003

IBM to Ship DB2 Information Integrator

http://www.eweek.com/article2/0,3959,1090232,00.asp?kc=EWRSS02129TX1K0000531
7:47:26 PM    comment []


Message: 9 Date: Thu, 15 May 2003 13:40:02 -0400 From: "Rosemary Lieberman" < rosemary@microflo.com > Subject: RE: HELP!

Dear George:

Copy and Run this in Query Analyzer by clicking on the green right triangle! This will add a user-defined function that when called via the print command, prints the current MDAC version. (Use Master)

--*************************************************************** CREATE FUNCTION GetMDAC () RETURNS varchar(255) AS

BEGIN DECLARE @Vs varchar( 250 ) EXEC master..xp_regread N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftDataAccess', N'FullInstallVer' , @Vs OUT , N'no_output' RETURN (@Vs) END

--command to run: PRINT dbo.GetMDAC() --*****************************************************************

Now in Q/A,

Type, copy from above, or just highlight and click execute the following:

PRINT dbo.GetMDAC()

On my machine this prints:

/*----------------------------- PRINT dbo.GetMDAC() -----------------------------*/ 2.71.9030.9

Regards,

ro
6:00:09 PM    comment []


Fwd: [magicsolutions] Digest Number 394

magicsolutions@yahoogroups.com wrote: Date: 5 May 2003 02:37:40 -0000 From: magicsolutions@yahoogroups.com To: magicsolutions@yahoogroups.com Subject: [magicsolutions] Digest Number 394

------------------------ Yahoo! Groups Sponsor ---------------------~--> Make Money Online Auctions! Make $500.00 or We Will Give You Thirty Dollars for Trying! http://us.click.yahoo.com/KXUxcA/fNtFAA/uetFAA/NhFolB/TM ---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to: magicsolutions-unsubscribe@yahoogroups.com

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

There is 1 message in this issue.

Topics in this digest:

1. Re: Re: Software Inventory From: "Rosemary Lieberman"

________________________________________________________________________ ________________________________________________________________________

Message: 1 Date: Sat, 3 May 2003 23:32:52 -0400 From: "Rosemary Lieberman" Subject: Re: Re: Software Inventory

Dear Shelly,

Are you using Configurations that are tied to the Client?

I don't see the need for a "Unique" identifier for each software installation. You would track the number of licenses available on the Inventory Item for the software as the quantity and then assign the software to each user's configuration. In this manner, when all licenses are used up, you would see 0 available. Conversely, when a software item is uninstalled from a PC or the PC is placed out of service, you would simply unassign the software from the user's configuration which would then make that license available again and increase the quantity available.

You can perform quite sophisticated Inventory and Asset management within Magic. Why don't you layout your current plan for your implementation and I will be happy to critique and offer suggestions.

ro

Rosemary Lieberman, Microflo Software, LLC Tel: (201)225-0800 Cell: (973)818-2260 Email: rosemary@microflo.com Web: www.microflo.com

Microflo provides expert consulting services for MagicTSD and Crystal Reports.

----- Original Message ----- From: Shelly To: magicsolutions@yahoogroups.com Sent: Saturday, May 03, 2003 7:57 PM Subject: [magicsolutions] Re: Software Inventory

We are in the early stages of asset management and have worked out how to handle our hardware inventory and future software purchases. The question for us is how to track our existing software. We've got the data, that's not an issue. Our issue is that we have no unique identifier for each software installation. For future purchases we were planning on using purchase order number. If you have any ideas or suggestions, I would love to hear them.

Thanks,

Shelly

--- In magicsolutions@yahoogroups.com, "Fraysier, Roni" wrote: > I am going to start tracking software in Magic and am looking for some > suggestions on the best way to go about it. We have a base image that > all PCs are cloned with, but different departments require additional > software and several departments might use the same software package. > Since one PC can have several 3rd party apps, I would really like to > have a list and be able to select all that apply and have Magic retain > that, but I don't think it has the capability does it? (If it does, > please tell me more!!) Will I have to create a field for each > application with an on/off checkbox? I'd like to also thank the list > for all the wonderful suggestions everyone is so willing to share, makes > my job much easier! > > Roni Fraysier > Help Desk Manager > Computing & Information Technology > University of Wisconsin - Green Bay > fraysier@u... > > The information contained in this email message is privileged and > confidential, intended only for the use of the individual(s) named > above. If the reader is not the intended recipient, you are hereby > notified that any dissemination or copying of this communication is > prohibited.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to: magicsolutions-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[This message contained attachments]

________________________________________________________________________ ________________________________________________________________________

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

JF

--------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
6:19:09 AM    comment []


© Copyright 2003 John Finnerty.
 
May 2003
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
Apr   Jun


Links

JF Links


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.