Re: [ubuntu-uk] MS SQL

2011-01-21 Thread Alan Lord (News) 

On 21/01/11 07:07, bod...@googlemail.com wrote:


Trying to convince management to buy another product is gonna be hard. I
was hoping for someway of doing it through SQL tools.


Erm, who said anything about "buying"?

You can download it, and some documentation for free: 
http://www.ocsinventory-ng.org/index.php?page=2-0-rc1


Al


--
The Open Learning Centre
http://www.theopenlearningcentre.com


--
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/

Re: [ubuntu-uk] MS SQL

2011-01-20 Thread bodsda 
Unfortunately, we already have one. Our call logging system has a cmdb element, 
but it is nothing better than a list of servers with not much info.

Trying to convince management to buy another product is gonna be hard. I was 
hoping for someway of doing it through SQL tools.

I'll definitely look into ocsi 

Cheers,
Bodsda
Sent from my BlackBerry® wireless device

-Original Message-
From: Dan Attwood 
Date: Thu, 20 Jan 2011 13:23:48 
To: ; UK Ubuntu Talk
Subject: Re: [ubuntu-uk] MS SQL

why not have a look around for an asset management system that's already
built? such as : http://www.ocsinventory-ng.org/

-- 
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/

Re: [ubuntu-uk] MS SQL

2011-01-20 Thread Sean Miller 
PHP/HTML with MySQL works very well, if you're confident building a user
interface.

Just a case of building some viewing screens and some data entry screens.

Sean
-- 
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/

Re: [ubuntu-uk] MS SQL

2011-01-20 Thread Alan Lord (News) 

On 20/01/11 13:57, John Stevenson wrote:

I agree with the comment from Dan, ditch your spreadsheet asap and get
something specific, before the spreadsheet becomes a noose around your neck.


Unless it's a very simple requirement then why not just use OOo Base and 
MySQL? You can run that on Windows or Ubuntu or MACs.



You could look for a helpdesk / ticket/issue management tool that lets
you record your inventory, that way you can also record issues occurring
on specific hardware.  A nice (commercial) example of this is called
Service-now.com .  I am sure there are issue
management tools for Linux that do the same thing, I can think of
http://otrs.org , although I have not used this in a
while so dont remember all the features but it looked good at the time.


There are many professional and full featured systems. OTRS is a good 
one, as are Redmine, RT, OSTicket & some others.


Also you could think along the lines of a highly modular ERP system such 
as OpenERP that has Asset and Project Management capabilities.


Lots of ways...

Al

--
The Open Learning Centre
http://www.theopenlearningcentre.com


--
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/

Re: [ubuntu-uk] MS SQL

2011-01-20 Thread John Stevenson 
On 20 January 2011 13:18,  wrote:

> Hi guys,
>
> This is more microsoft related than ubuntu related, but am just after some
> advice.
>
> We currently use a spreadsheet to manage our server information and asset
> documentation. I am keen to put this into a SQL db, but have a slight
> problem. I am happy with editing tables to insert/view/delete data but my
> managers won't be. What can I use to build on top of SQL to provide a
> dummies interface to interact with the db?
>
> Thanks,
> Bodsda
>

I agree with the comment from Dan, ditch your spreadsheet asap and get
something specific, before the spreadsheet becomes a noose around your neck.

You could look for a helpdesk / ticket/issue management tool that lets you
record your inventory, that way you can also record issues occurring on
specific hardware.  A nice (commercial) example of this is called
Service-now.com.  I am sure there are issue management tools for Linux that
do the same thing, I can think of http://otrs.org, although I have not used
this in a while so dont remember all the features but it looked good at the
time.

Thanks
-- 
John Stevenson
Lean Agile Consultant / Coach
jr0cket.com  |  leanagilemachine.com
-- 
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/

Re: [ubuntu-uk] MS SQL

2011-01-20 Thread Dan Attwood 
why not have a look around for an asset management system that's already
built? such as : http://www.ocsinventory-ng.org/
-- 
ubuntu-uk@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk
https://wiki.ubuntu.com/UKTeam/