ya lo logre era muy simple, utilizando el server de la empresa y los servicios que este brinda... aca les dejo un codig de que fue lo que hice
Código asp:
Ver original<%
Set cn = Server.CreateObject("ADODB.Recordset")'creando objeto para la conexion
Set cn1 = Server.CreateObject("ADODB.Recordset")'creando objeto para la conexion
'activando la conexion con el servidor y el ususario y password deseado en el DNS,osea en el ODBC
cn.ActiveConnection = "Server=sbw2k22;DSN=sla;UID=usr_hpsd;PWD=qwer1234;"
cn1.ActiveConnection = "Server=sbw2k22;DSN=sla;UID=usr_hpsd;PWD=qwer1234;"
equipo="(itsm_workgroups.wog_name='Evaluación del Negocio' or itsm_workgroups.wog_name='Procesos Comerciales' or itsm_workgroups.wog_name='Soporte Comercial' or itsm_workgroups.wog_name='Información Comercial' or itsm_workgroups.wog_name='Administración de Hardware y Software' or itsm_workgroups.wog_name='Administración HP Openview Service Desk' or itsm_workgroups.wog_name='Analista BO de EDC3264' or itsm_workgroups.wog_name='Analista de EDC3264' or itsm_workgroups.wog_name='Data Center' or itsm_workgroups.wog_name='Gestión de Proyecto' or itsm_workgroups.wog_name='Gestion Integral ISO' or itsm_workgroups.wog_name='Inmuebles' or itsm_workgroups.wog_name='Seguridad de Información' or itsm_workgroups.wog_name='Servicios Generales - Centro de Fotocopiado' or itsm_workgroups.wog_name='Servicios Generales - Chacao' or itsm_workgroups.wog_name='Servicios Generales - ' or itsm_workgroups.wog_name='Servicios Generales - El Márques' or itsm_workgroups.wog_name='Servicios Generales - Genevap,CA' or itsm_workgroups.wog_name='Servicios Generales - Guarenas' or itsm_workgroups.wog_name='Servicios Generales - La Guaira' or itsm_workgroups.wog_name='Servicios Generales - La Yaguara' or itsm_workgroups.wog_name='Servicios Generales - Los Teques' or itsm_workgroups.wog_name='Servicios Generales - OAM' or itsm_workgroups.wog_name='Servicios Generales - Oficinas Comerciales' or itsm_workgroups.wog_name='Servicios Generales - San Bernardino' or itsm_workgroups.wog_name='Servicios Generales - San Felipe' or itsm_workgroups.wog_name='Servicios Generales - Santa Rosa' or itsm_workgroups.wog_name='Soluciones Colaborativas' or itsm_workgroups.wog_name='Soluciones de Negocio Comerciales' or itsm_workgroups.wog_name='Soluciones de Negocio Financieras' or itsm_workgroups.wog_name='Soluciones de Negocio Operacionales' or itsm_workgroups.wog_name='Soporte en Sitio - Central' or itsm_workgroups.wog_name='Soporte en Sitio - Metro Foráneo' or itsm_workgroups.wog_name='Telecom - Fibra Optica' or itsm_workgroups.wog_name='Telecom - Internetworking' or itsm_workgroups.wog_name='Telecom - Telefonia' or itsm_workgroups.wog_name='Telecom - Transmision de Voz y Datos')"
%>
<%
sql="select count(distinct(inc_id))as cuenta from itsm_incidents,rep_codes,rep_codes_text,itsm_workgroups where (inc_sta_oid=rcd_oid) and (rct_rcd_oid=rcd_oid) and (RCT_NAME='Despachada' or RCT_NAME='Aceptada'OR RCT_NAME='Asignada'OR RCT_NAME='Cerrada QA'OR RCT_NAME='Cerrada'OR RCT_NAME='Confirmación'OR RCT_NAME='Despachada'OR RCT_NAME='Documentación Completada'OR RCT_NAME='En Ejecución'OR RCT_NAME='En Espera'OR RCT_NAME='Finalizada'OR RCT_NAME='No Aceptada'OR RCT_NAME='Pendiente por Documentación'OR RCT_NAME='Registrada'OR RCT_NAME='Resuelta') and (itsm_workgroups.wog_oid=itsm_incidents.inc_assign_workgroup) and "&equipo&" and (itsm_incidents.inc_actualfinish is null)"
cn.Source=sql
cn.open
cuenta=cn("cuenta")
cn.close
sql="select distinct(inc_id),rct_name,itsm_incidents.reg_created,inc_actualfinish,inc_deadline,inc_description,ini_information,itsm_persons.per_name from itsm_incidents,rep_codes,rep_codes_text,itsm_workgroups,itsm_inc_information,itsm_persons where (itsm_incidents.inc_assign_person_to=itsm_persons.per_oid) and (inc_oid=ini_inc_oid) and (inc_sta_oid=rcd_oid) and (rct_rcd_oid=rcd_oid) and (RCT_NAME='Despachada' or RCT_NAME='Aceptada'OR RCT_NAME='Asignada'OR RCT_NAME='Cerrada QA'OR RCT_NAME='Cerrada'OR RCT_NAME='Confirmación'OR RCT_NAME='Despachada'OR RCT_NAME='Documentación Completada'OR RCT_NAME='En Ejecución'OR RCT_NAME='En Espera'OR RCT_NAME='Finalizada'OR RCT_NAME='No Aceptada'OR RCT_NAME='Pendiente por Documentación'OR RCT_NAME='Registrada'OR RCT_NAME='Resuelta') and (itsm_workgroups.wog_oid=itsm_incidents.inc_assign_workgroup) and "&equipo&" and (itsm_incidents.inc_actualfinish is null)"
cn.Source=sql
cn.open
sql="select distinct(inc_id),rct_name,itsm_incidents.reg_created,inc_actualfinish,inc_deadline,inc_description,ini_information from itsm_incidents,rep_codes,rep_codes_text,itsm_workgroups,itsm_inc_information,itsm_persons where (itsm_incidents.inc_assign_person_to is null) and (inc_oid=ini_inc_oid) and (inc_sta_oid=rcd_oid) and (rct_rcd_oid=rcd_oid) and (RCT_NAME='Despachada' or RCT_NAME='Aceptada'OR RCT_NAME='Asignada'OR RCT_NAME='Cerrada QA'OR RCT_NAME='Cerrada'OR RCT_NAME='Confirmación'OR RCT_NAME='Despachada'OR RCT_NAME='Documentación Completada'OR RCT_NAME='En Ejecución'OR RCT_NAME='En Espera'OR RCT_NAME='Finalizada'OR RCT_NAME='No Aceptada'OR RCT_NAME='Pendiente por Documentación'OR RCT_NAME='Registrada'OR RCT_NAME='Resuelta') and (itsm_workgroups.wog_oid=itsm_incidents.inc_assign_workgroup) and "&equipo&" and (itsm_incidents.inc_actualfinish is null)"
cn1.Source=sql
cn1.open
%>
<%
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Informe Insidencias diarias abiertas"&year(date())&" al "&day(date())&"/"&month(date())&"/"&year(date())
html="<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>"
html=html&"<html>"
html=html&"<head>"
html=html&"<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>"
html=html&"<title>Llamadas de servicio NO resueltas</title>"
html=html&"<style type='text/css'>"
html=html&"<!--.style4 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #FFFFFF; font-weight: bold; }"
html=html&".style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px;}"
html=html&".style11 {font-family: Verdana, Arial, Helvetica, sans-serif}"
html=html&".style12 {font-size: 12px}"
html=html&".style9 {font-size: 12px; font-weight: bold; font-family: Verdana, Arial, Helvetica, sans-serif;}-->"
html=html&"</style>"
html=html&"</head>"
html=html&"<body>"
html=html&"<table width='296' border='1' cellspacing='0' cellpadding='0'>"
html=html&"<tr bgcolor='#003399'>"
html=html&"<td width='103' height='29'><div align='center' class='style4'>Id caso</div></td>"
html=html&"<td width='262'><div align='center' class='style4'>Descripción</div></td>"
html=html&"</tr>"
do while not cn1.Eof
id=cn1("inc_id")
desc=cn1("inc_description")
html=html&"<tr align='center' valign='middle'>"
html=html&"<td><div align='center' class='style6'>"&(id)&"</div>"
html=html&"<td><div align='center' class='style6'>"&(desc)&"</div><div align='center' class='style6'></div></td>"
cn1.MoveNext
loop
cn1.close
html=html&"</tr>"
do while not cn.Eof
id1=cn("inc_id")
desc1=cn("inc_description")
html=html&"<tr align='center' valign='middle'>"
html=html&"<td><div align='center' class='style6'>"&(id1)&"</div>"
html=html&"<td><div align='center' class='style6'>"&(desc1)&"</div>"
html=html&"<div align='center' class='style6'></div></td>"
cn.MoveNext
loop
cn.close
html=html&"</tr>"
html=html&"</table>"
html=html&"</body>"
html=html&"</html>"
objMessage.HTMLBody =html
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "10.2.101.63"
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMessage.Configuration.Fields.Update
objMessage.Send
Set objMessage = Nothing
%>