Jump to content

Search the Community

Showing results for tags 'sql query'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • CA Service Desk Manager
    • General Discussions
    • Customizations / Modifications
    • Bugs / Errors / Patches
    • Knowledge Tools / Keyword Search
    • Support Automation
    • CMDB
    • Install / Migrate / Configure
    • Product Integration
    • Reporting
    • Workflow
  • Nimsoft Service Desk
    • General
  • General
    • Wiki Article Discussions
    • ITIL & Best Practices
    • Speak Out
    • Employment Opportunities

Categories

  • Getting Started
  • Installation
  • Configuration
  • Customization
  • Integration
    • CA Applications
    • Non-CA Applications
    • Custom Integrations
  • Reporting
  • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 2 results

  1. Hi community! I need some help to create a query to shows this fields , actually i worked in this query and i have some fields but i require the fields bellow: Field Table pri_phone_number ca_contact zloc_cnt usp_contact zip ca_location alt_phone_number ca_contact zbusiness_hrs usp_contact serial_number ca_owned_resource This is the actual query , but i dont know any of sql and i dont know wich related tables and their keys works to show the required field select ref_num, zmerchant_cnt, rc.sym as Rootcause, assignee, cr.tenant, convert(varchar(20), dateadd (ss, cr.last_mod_dt -21600, '1/1/1970') , 101) + ' ' + + LTRIM(RIGHT(CONVERT(CHAR(20), dateadd (ss, cr.last_mod_dt -21600, '1/1/1970'), 22), 11)) as [Last Modified Date], convert(varchar(20), dateadd (ss, call_back_date -21600, '1/1/1970') , 101) + ' ' + + LTRIM(RIGHT(CONVERT(CHAR(20), dateadd (ss, call_back_date -21600, '1/1/1970'), 22), 11)) as [Call Back Date] from call_req cr inner join rootcause rc on cr.id=rc.id Can you help me with this pls ? :C
  2. Hi! I need to make some querys directly to a clone of my CA SDM database, but i would need to see some querys examples to start. Is there any pleace where i could get this examples? Best regards, Miguel Amaral
×
×
  • Create New...