create procedure ujo_get_machine
@machine_name varchar(80)

as
    declare @machine_type char(1)

    if @machine_name = 'ALL'
        select distinct name, parent_name, que_name, type, factor, max_load, mstatus
        from ujo_machine
    else
    begin
        if exists (select name from ujo_machine where name = @machine_name)
            select name, parent_name, que_name, type, factor, max_load, mstatus
            from ujo_machine where
            name = @machine_name or
            parent_name = @machine_name or
            que_name = @machine_name
        --else
        --    print 'machine is not defined to AutoSys'
    end
return -999 /*SUCCESS*/
GO
GRANT EXECUTE ON  [dbo].[ujo_get_machine] TO [ujoadmin]
GO