I wrote a SQL report to list all the machines that do not match our department naming rules.  It runs but it only filters on the first 20 items, I have 64 in the list.

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, LAST_SYNC
FROM MACHINE
WHERE
    (SYSTEM_DESCRIPTION NOT LIKE '%Adult_Basic_Education%'
or SYSTEM_DESCRIPTION NOT LIKE '%Academic_Affairs_and_Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Academic_Support_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Accounting_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Admissions_and_Records%'
or SYSTEM_DESCRIPTION NOT LIKE '%Advisement_and_Transfer_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Biology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Budget_and_Planning%'
or SYSTEM_DESCRIPTION NOT LIKE '%Child_Care_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Computer_Technologies%'
or SYSTEM_DESCRIPTION NOT LIKE '%Counseling%'
or SYSTEM_DESCRIPTION NOT LIKE '%Culinary_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Dental_Assisting%'
or SYSTEM_DESCRIPTION NOT LIKE '%Dental_Hygiene%'
or SYSTEM_DESCRIPTION NOT LIKE '%Disability_Resource_Cente%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Applied_Industrial_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Business%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Liberal_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Web_College%'
or SYSTEM_DESCRIPTION NOT LIKE '%EMS-Paramedic%'
or SYSTEM_DESCRIPTION NOT LIKE '%English%'
or SYSTEM_DESCRIPTION NOT LIKE '%Equity_and_Inclusion%'
or SYSTEM_DESCRIPTION NOT LIKE '%Facility_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Faculty_Senate%'
or SYSTEM_DESCRIPTION NOT LIKE '%Finance_and_Administrative_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Financial_Aid%'
or SYSTEM_DESCRIPTION NOT LIKE '%Financial_Aid_and_Student_Success%'
or SYSTEM_DESCRIPTION NOT LIKE '%Fire_Science%'
or SYSTEM_DESCRIPTION NOT LIKE '%History_Political_Science_and_Law%'
or SYSTEM_DESCRIPTION NOT LIKE '%Human_Resources%'
or SYSTEM_DESCRIPTION NOT LIKE '%Humanities%'
or SYSTEM_DESCRIPTION NOT LIKE '%Information_Technology_Operations%'
or SYSTEM_DESCRIPTION NOT LIKE '%Information_Technology_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Institutional_Advancement_/_Foundation%'
or SYSTEM_DESCRIPTION NOT LIKE '%Institutional_Research%'
or SYSTEM_DESCRIPTION NOT LIKE '%Instructional_Support%'
or SYSTEM_DESCRIPTION NOT LIKE '%Liberal_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Library%'
or SYSTEM_DESCRIPTION NOT LIKE '%Mathematics%'
or SYSTEM_DESCRIPTION NOT LIKE '%New_Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Nutrition%'
or SYSTEM_DESCRIPTION NOT LIKE '%Nursing%'
or SYSTEM_DESCRIPTION NOT LIKE '%Outreach_and_Recruitment%'
or SYSTEM_DESCRIPTION NOT LIKE '%Physical_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%President%'
or SYSTEM_DESCRIPTION NOT LIKE '%Professional_Development%'
or SYSTEM_DESCRIPTION NOT LIKE '%Police_and_Public_Safety%'
or SYSTEM_DESCRIPTION NOT LIKE '%Radiologic_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Redfield_High_Tech_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Re-Entry/Job_Prep/Career%'
or SYSTEM_DESCRIPTION NOT LIKE '%Retention_Support_Programs%'
or SYSTEM_DESCRIPTION NOT LIKE '%Scheduling%'
or SYSTEM_DESCRIPTION NOT LIKE '%Skills_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Social_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Outreach%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Activities_and_Leadership%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Tutoring_and_Learning_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Veterans_Upward_Bound%'
or SYSTEM_DESCRIPTION NOT LIKE '%Veterinary_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Visual_and_Performing_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%WDCE%')
 ORDER BY SYSTEM_DESCRIPTION asc,MACHINE.NAME asc

Answer Summary:
changed the or's to and's
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

I haven't heard of one before. This might be a question for support to double check for you. 

Answered 10/18/2012 by: nshah
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity