If you only want to generate a report for CIs (only unique name) with attachments, then you may search for the same in SYSATTACHMENTS table but that is a separate table and you won't be able to see other details of CIs.
I only want to look for and list all CIs (with details) which have attachments (no information like name, contents, etc about attachments needed). Is there any possibility to do it subtly without doing SELECT on the sql database etc?
Ok... but that doesn't tell us what you're trying to do.
As Akhil said, all attachments in the system (regardless of which module they come from) are stored in the SYSATTACHMENTS table. The system uses the unique key of the record in the module to determine which attachments belong to which records.
So, the SYSATTACHMENTS table can tell you which records in the device table have attachments, but it won't give you any information about those CIs, since that information is stored in the device table.
As I said, there's no OOB method to do what you're asking, so to help, we need to know what it is you're doing.
1. I want to create a view in Configuration Item called for example 'All devices with attachments' which show me list of all devices with attachments. I only need information that there is or not an attachment (without any other details or links to attachments).
2. If possible, I want to add a checkbox 'Attachment' in Configuration Item Search which give me ability to looking for different information about CIs only among CIs with attachments.
I'll see what I can come up with for your second requirement.
Use Database Manager and look for the table named "SearchConfig"
Then, look for the record for the "device" table.
Add the following to the Defined Queries tab:
ID: withAttach Query: logical.name isin jscall("FindAttachments.Search", "device") Description: With Attachments